6. QUEL and EQUEL Statements : Destroy Statement--Destroy Tables, Views, Permissions, Integrities : Description
 
Share this page                  
Description
Destroy removes tables from the database, or integrity constraints and permissions from a table or view. Only the owner is allowed to destroy a table or its permissions and integrity constraints. Destroying a table destroys all views built on that table.
If the table being destroyed has secondary indexes, the secondary indexes are also destroyed. You can destroy a secondary index separately, without affecting the base table.
To destroy individual permissions or constraints for a table, you must use the integer argument. Use the help permit statement (for permissions) or a help integrity statement (for constraints) to display the argument values for the various individual permissions and constraints. To destroy all constraints or permissions, specify all.
Destroy accepts a maximum of 30 arguments. To destroy more than 30 objects, you must use multiple destroy statements.