DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.TABDETACHEDDEP catalog view

Each row represents a detached dependency between a detached dependent table and a detached table.

Table 1. SYSCAT.TABDETACHEDDEP Catalog View
Column Name Data Type Nullable Description
TABSCHEMA VARCHAR (128)   Schema name of the detached table.
TABNAME VARCHAR (128)   Unqualified name of the detached table.
DEPTABSCHEMA VARCHAR (128)   Schema name of the detached dependent table.
DEPTABNAME VARCHAR (128)   Unqualified name of the detached dependent table.