B.10 DROP TABLE

This statement deletes a table from a Windows® CE–based device.

DROP TABLE tablename

Parameters

tablename

The name of the table to delete.

Return Values

One of the following error values can be returned:

• E_OUTOFMEMORY
• DB_E_ERRORSINCOMMAND
• DB_E_NOTABLE

Remarks

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

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