Previous Topic: SYSCONSTRSRC (CNS)


SYSVIEWDEP (VWD)

SYSVIEWDEP has one row for each dependency between a table (or view) and a view.

Column Name

Data Type

Description

BNAME

CHAR(32)

The Table or View DNAME is dependent on.

BCREATOR

CHAR(18)

Authorization ID of BNAME

BTYPE

CHAR

BNAME is 'T' - table, 'V' - view

DNAME

CHAR(32)

Name of the View

DCREATOR

CHAR(18)

Authorization ID of DNAME