Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## DROP TABLE

> Deletes the specified table.

> #### Syntax

>     DROP TABLE  [ owner_name.]table_name ;

> ``owner_name``

> Specifies the owner of the table.

> ``table_name``

> Names the table to drop.

> Example

>     DROP TABLE customer ;

> #### Notes

> - If owner_name is specified and is different from the name of the user executing the statement, then the user must have `DBA` privileges.

> - When a table is dropped, the indexes on the table and the privileges associated with the table are dropped automatically.

> - Views dependent on the dropped table are not automatically dropped, but become invalid.

> - If the table is part of another table's referential constraint (if the table is named in another table’s `REFERENCES` clause), the `DROP TABLE` statement fails. You must `DROP` the referring table first.

> ##### Authorization

> Must have `DBA` privilege or ownership of the table.

> ##### Related statements

> CREATE TABLE

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