Database Reference
In-Depth Information
Example 4:
The following statements create two snapshot relations: the first
one stores Computer Science courses only; the second stores Computer Science and
Information Systems majors only.
11.7 Dropping or Modifying a Table
A table may be dropped (deleted from the system) via the
Drop-Table
statement. The
syntax is:
To drop all referential integrity constraints that refer to primary and unique keys in
the dropped table, specify the
Cascade-Constraints-Clause
. If you omit this clause, and
such referential integrity constraints exist, Oracle will return an error and will not drop
the table.
Example 5:
The following statement removes table
CSCourses
from the system: