DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.TABDEP catalog view

Each row represents a dependency of a view or a materialized query table on some other object. The view or materialized query table depends on the object of type BTYPE of name BNAME, so a change to the object affects the view or materialized query table. Also encodes how privileges on views depend on privileges on underlying tables and views.

Table 1. SYSCAT.TABDEP Catalog View
Column Name Data Type Nullable Description
TABSCHEMA VARCHAR (128)   Schema name of the view or materialized query table.
TABNAME VARCHAR (128)   Unqualified name of the view or materialized query table.
DTYPE CHAR (1)   Type of the depending object.
  • S = Materialized query table
  • T = Table (staging only)
  • V = View (untyped)
  • W = Typed view
OWNER VARCHAR (128)   Authorization ID of the creator of the view or materialized query table.
OWNERTYPE CHAR (1)  
  • U = The owner is an individual user
BTYPE CHAR (1)   Type of object on which there is a dependency. Possible values are:
  • A = Table alias
  • F = Routine
  • I = Index, if recording dependency on a base table
  • G = Global temporary table
  • N = Nickname
  • O = Privilege dependency on all subtables or subviews in a table or view hierarchy
  • R = User-defined structured type
  • S = Materialized query table
  • T = Table (untyped)
  • U = Typed table
  • V = View (untyped)
  • W = Typed view
  • Z = XSR object
  • m = Module
  • u = Module alias
  • v = Global variable
BSCHEMA VARCHAR (128)   Schema name of the object on which the view or materialized query table depends.
BMODULENAME VARCHAR (128) Y Unqualified name of the module to which the object on which there is a dependency belongs. The null value if not a module object.
BNAME VARCHAR (128)   Unqualified name of the object on which the view or materialized query table depends.
BMODULEID INTEGER Y Identifier for the module of the object on which the view or materialized query table depends.
TABAUTH SMALLINT Y If BTYPE is 'N', 'O', 'S', 'T', 'U', 'V', or 'W', encodes the privileges on the underlying table or view on which this view or materialized query table depends; the null value otherwise.
VARAUTH SMALLINT Y If BTYPE is 'v', encodes the privileges on the underlying global variable on which this view or materialized query table depends; the null value otherwise.
DEFINER1 VARCHAR (128)   Authorization ID of the creator of the view or materialized query table.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.