SAND CDBMS SQL Reference Guide
SAND CDBMS SQL Database Objects and Language Elements


Previous Topic:
Chapter Index
Next Topic:


Dependencies Among Database Objects

Database objects that are defined with reference to other objects are said to be dependent on those objects. In SAND CDBMS SQL, dependent objects include the following:

In addition, any database object created by an authorization (except for the user password) is dependent on that authorization, and any object defined within a schema depends on that schema.

SAND CDBMS automatically tracks the dependencies among the objects in a given database, allowing for the enforcement of certain rules on dependent objects when the "parent" object is destroyed (using the DROP command). These rules are called drop behaviors.

Drop Behavior

Dependencies are an important consideration whenever a database object is destroyed or "dropped". In SAND CDBMS SQL, drop behavior is as follows:

In the latter case, all dependent objects must be dropped before the "parent" object can be dropped.