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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]