SYSDEPEND
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.
| 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.