Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 23 of 30
To remove a table or an object table and all its data from the database.
For information on creating tables, see "CREATE TABLE". For information on modifying tables, see "ALTER TABLE".
The table must be in your own schema or you must have the DROP
ANY
TABLE
system privilege.
schema |
is the schema containing the table. If you omit schema, Oracle assumes the table is in your own schema. |
table |
is the name of the table, object table, or index-organized table to be dropped. Oracle automatically performs the following operations: |
|
See Also: Oracle8i Data Cartridge Developer's Guide for more information on these routines. |
|
See Also: "ASSOCIATE STATISTICS" and "DISASSOCIATE STATISTICS" for more information on statistics type associations. |
|
|
|
|
|
|
|
Note: To drop a cluster and all its the tables, use the |
|
drops all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, Oracle returns an error and does not drop the table. |
The following statement drops the TEST_DATA
table:
DROP TABLE test_data;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|