What is the use of CASCADE CONSTRAINTS
DROP TABLE table_name CASCADE CONSTRAINTS;
When this clause is used with DROP command, it deletes all foreign keys that reference the table to
be dropped, then drops the table.
i.e., parent table can be dropped even when a child table exists.
i.e., parent table can be dropped even when a child table exists.
DROP TABLE table_name CASCADE CONSTRAINTS;
No comments:
Post a Comment