What is the use of CASCADE CONSTRAINTS?

The CASCADE CONSTRAINTS clause drops all referencial integrity constraints that refer to the primary and unique keys defined on the dropped columns.