By default the CASCADE CONSTRAINTS and PURGE option are included in a DROP TABLE.

Name: By default the CASCADE CONSTRAINTS and PURGE option are included in a DROP TABLE.
Brand: Quizplus
Rating: 4.9 (36 reviews)

Question

Quizplus · Accepted Answer

By default, the DROP TABLE statement does not include CASCADE CONSTRAINTS or PURGE. CASCADE CONSTRAINTS must be explicitly specified to drop any dependent objects, and PURGE must be specified to skip the recycle bin for the table being dropped.

By Default the CASCADE CONSTRAINTS and PURGE Option Are Included