Progress
SQL-89
Guide and Reference


Deleting Tables

The DROP TABLE statement deletes a table from the database. It also deletes all indexes defined on that table, all access privileges, and all data associated with the table. Following is the syntax of the DROP TABLE statement.

SYNTAX
DROP TABLE table-name 

The following example deletes a table named cust_table.

DROP TABLE Cust_Table. 

Only the owner of a table can delete that table. You cannot delete a table that is referenced in a view definition.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095