Background documentation-1755: SQL statement will drop further objects (use CASCADE) Locate this document in the navigation structure

 

Explanation

A DROP USER, DROP TABLE, DROP VIEW or REVOKE statement was specified for which the CASCADE option had not been specified implicitly or explicitly. Other objects depend on the object to be deleted. These objects must be deleted as well. But this is only possible with an implicit or explicit specification of the CASCADE option.

User Response

Before specifying the same SQL statement with the CASCADE option, you should check which dependent objects exist.