The sysdepend system catalog table describes how each view or table depends on other views or tables. One row exists in this table for each dependency, so a view based on three tables has three rows. The sysdepend table has the following columns.
Table 1. SYSDEPEND table column descriptions
Column Type Explanation
btabid INTEGER Code uniquely identifying the base table or view
btype CHAR(1) Base object type: T = Table V = View
dtabid INTEGER Code uniquely identifying a dependent table or view
dtype CHAR(1) Code for the type of dependent object; currently, only view (V = View) is implemented

The btabid and dtabid columns are indexed and allow duplicate values.