Removes a table from the database.
| table_name | Name of the table you want to drop from the database. |
The DROP TABLE command removes an existing table from the database. To execute the DROP TABLE command you must be the table owner, or have DBA or SYSADM security privileges.
When you drop a table, DBMaker will also drop all indexes and primary keys on the table. If the table has a primary key which is referenced by one or more foreign keys, you must drop all foreign keys that reference the primary key before you can drop the table. You cannot drop any system tables.
The following example drops the Employees table from the database.
|