DROP TABLE
This statement removes a table.
Source Code
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.
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
| 
Dev Corner
