DEPENDENCIES System Table Description

From the release of NuoDB 3.4, this table is deprecated and no longer contains valid data. For more information on features deprecated in this release, see Deprecated Features.

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