How do RESTRICT and CASCADE differ in DROP TABLE PropertyForRent RESTRICT versus CASCADE ?

Question

How do RESTRICT and CASCADE differ in  DROP TABLE PropertyForRent RESTRICT  versus  CASCADE ?

Accepted Answer

RESTRICT rejects the drop if other objects depend on the table; CASCADE drops the table together with all dependent objects.

Answer

CASCADE rejects the drop if other objects depend on the table; RESTRICT drops them too.

Answer

RESTRICT drops the table and its rows; CASCADE only drops the rows.

Answer

RESTRICT works only on views; CASCADE works only on base tables.

Crowdly