Database Reference
In-Depth Information
Figure 18.22
The Table
RELEASESIN2001
Renamed to
NEW_RELEASES
_IN_2001.
18.5
Dropping a Table
Dropping a table is a very simple command, as shown in the DROP table
command that follows. Figure 18.23 shows syntax for the DROP TABLE
command.
DROP TABLE NEW_RELEASES_FOR_2001;
When you drop a table, the following items are automatically dropped
along with the table:
Indexes on the table.
Constraints on the table, including any primary key and foreign key
constraints.
Object privileges granted on the table (Chapter 23 contains informa-
tion about object privileges and security in general.)
When you drop a table, these items are not dropped, but are marked
invalid and must be corrected later:
Views containing the table.
Foreign keys in other tables referencing the dropped table.
Synonyms referencing the table (see Chapter 22).
All PL/SQL named procedures, functions, and triggers that reference
the dropped table (see Chapter 24).
