DROP TABLE

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

Syntax

DROP TABLE tablename

Parameters

tablename

Specifies 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.

Example

The following code example shows how to use the DROP TABLE statement in a SQL query.

Dim rs
Set rs = CreateObject("adoce.recordset")
rs.Open "create table allfields (f1 varchar)"
rs.Open "allfields"
MsgBox rs.fields.Count, , "Fields"
rs.Close
rs.Open "drop table allfields"
Set rs = Nothing