Contains a row for each dependency that packages have on indexes, tables,
views, functions, aliases, types, and hierarchies.
Table 112. OBJCAT.PACKAGEDEP Catalog View
Column Name | Data Type | Nullable | Description | ||
---|---|---|---|---|---|
PKGSCHEMA | CHAR(8) |
| Name of the package. | ||
PKGNAME | CHAR(8) |
| |||
BINDER |
CHAR(8) |
Yes |
Binder of the package. | ||
BTYPE |
CHAR(1) |
| Type of object BNAME:
| ||
BSCHEMA | CHAR(8) |
| Qualified name of an object on which the package is dependent. | ||
BNAME | VARCHAR(18) |
| |||
TABAUTH |
SMALLINT |
Yes |
If BTYPE is T(table) or V(view), encodes the privileges that are required by this package (Select, Insert, Delete, Update). | ||
|