Object Dependencies of the GaussDB Database

GaussDB 100 allows users to view dependency information between objects in the system. Users can view dependency relationships between objects based on the dependency information. In addition, when an object is modified, the status information of other objects that depend on the object is updated synchronously.

Currently, the following database objects are supported: Tables, views, sequences, synonyms, triggers, user-defined functions and stored procedures.

Currently, the dependency granularity is object-level dependency and does not support fine-grained dependency, such as table columns and stored procedure parameters.

When the object structure is changed, the status of the object that directly depends on or indirectly depends on is changed to UNKNOWN. However, the objects that depend on the object are not directly compiled.

The objects involved in dynamic SQL statements are not included in the dependency relationship. If an SQL statement uses a local temporary table, the SQL statement is regarded as a dynamic SQL statement and the involved objects are not included in the dependency relationship.

You can refer to the dependency between objects in the ALL_DEPENDENCIES, DBA_DEPENDENCIES and USER_DEPENDENCIES views.