DROP TABLE

This statement removes a table.

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 the device and destroys all data it contains. It is an irreversible process, so use this statement with care.

Example

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