Progress
SQL-92
Guide and Reference
DROP TABLE Statement
Deletes the specified table.
SYNTAX
owner_name
Specifies the owner of the table.
table_name
Names the table to drop.
EXAMPLE
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.
SQL COMPLIANCE
SQL-92, ODBC Minimum SQL grammar
ENVIRONMENT
Embedded SQL, interactive SQL, ODBC applications, JDBC applications
RELATED STATEMENTS
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |