Dropping Tables
To drop a table from the database, use a DROP TABLE statement.
DROP TABLE Student#
This example drops the InactiveStudents table definition from the data dictionary and deletes its corresponding data file (INACT.MKD).
For more information about the DROP TABLE statement, see the following topic in
SQL Engine Reference
:
DROP TABLE
.
Note:
You cannot drop any system tables. Refer to the
SQL Engine Reference
for a complete listing of system tables.