B.9 DROP DATABASE

This statement deletes a database from a Windows® CE-based device.

DROP DATABASE 'database_name.cdb' [,…n] 

Parameters

database_name

The name of the database to be removed. This name must be in single and have the database file (.cdb) extension.

n

Additional databases to be dropped in a comma-separated list.

Return Values

None.

Remarks

Dropping a database deletes a database from a device and destroys all data it contains. It is an irreversible process, so use this statement with care.

Use a comma-separated list to drop multiple databases.

An SQL statement cannot be longer than 2,048 characters. A longer statement causes an error.

This statement is available on the following platforms: Microsoft® Windows® CE, Handheld PC Professional Edition, Version 3.0, Microsoft® Windows® CE for the Palm-size PC, and Microsoft® Platform Builder version 2.12.