DEPENDENCIES System Table Description

Description

Maintains a list of database object dependencies, such as a table and a sequence, where the sequence is used to auto-generate a table column value.

Fields

Field Type Description
OBJECTTYPE integer

Specifies the type of object with the dependency specified in OBJECTNAME:

  • Table = 0
  • Trigger = 1
  • Sequence = 2
  • View = 3
  • Procedure = 4
  • Function = 5
OBJECTSCHEMA string Name of the schema containing the object that has a dependency on the object specified by DEPENDENCYNAME.
OBJECTNAME string Name of the object that has a dependency on the object specified by DEPENDENCYNAME.
DEPENDENCYTYPE integer

Specifies the type of the object specified in DEPENDENCYNAME:

  • Table = 0
  • Trigger = 1
  • Sequence = 2
  • View = 3
  • Procedure = 4
  • Function = 5
DEPENDENCYSCHEMA string Name of the schema containing the object on which the object specified by OBJECTNAME depends.
DEPENDENCYNAME string Name of the object on which the object specified by OBJECTNAME depends.

Indexes

Primary Index: DEPENDENCIES..PRIMARY_KEY on fields: OBJECTTYPE, OBJECTSCHEMA, OBJECTNAME, DEPENDENCYTYPE, DEPENDENCYSCHEMA, DEPENDENCYNAME

Example

After running the SQL QuickStart (see Running the SQL QuickStart), querying SYSTEM.DEPENDENCIES will result in the following. We use "SET OUTPUT VERTICAL" because it is more readable if displayed this way (see SET).

SET OUTPUT VERTICAL;
SELECT * FROM system.dependencies;
==================================== Row #1 ====================================
OBJECTTYPE: 0
OBJECTSCHEMA: HOCKEY
OBJECTNAME: HOCKEY
DEPENDENCYTYPE: 2
DEPENDENCYSCHEMA: HOCKEY
DEPENDENCYNAME: HOCKEY$IDENTITY_SEQUENCE