Progress
SQL-89
Guide and Reference


DROP TABLE Statement

Deletes a table from the database. It also deletes all indexes defined on that table and all access privileges, as well as all data.

SYNTAX
DROP TABLE table-name 

table-name

The name of the table to remove.

EXAMPLE

This example deletes the employee table from the database.

DROP TABLE Employee. 

NOTES

SEE ALSO

ALTER TABLE Statement, CREATE SCHEMA Statement (ESQL Only), CREATE TABLE Statement, GRANT Statement, REVOKE Statement


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