dropping database table which have referential constraints









Just drop table name; not suffice for dropping database table which have referential constraints.

We can do this using cascade option.

SQL>drop table TABLE cascade constraints