DBSCHEMA_CATALOGS Rowset
Identifies the physical attributes associated with catalogs accessible from the database management system (DBMS).
Rowset Columns
The DBSCHEMA_CATALOGS rowset contains the following columns.
| Column name | Type indicator | Length | Description |
|---|---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
255 |
The catalog name. Cannot be null. |
DESCRIPTION |
DBTYPE_WSTR |
A human-readable description of the table. |
|
ROLES |
DBTYPE_WSTR |
A comma delimited list of roles to which the current user belongs. An asterisk (*) is included as a role if the current user is a server or database administrator. Username is appended to ROLES if one of the roles uses dynamic security. |
|
DATE_MODIFIED |
DBTYPE_DBTIMESTAMP |
The date that the catalog was last modified. |
The rowset is sorted on CATALOG_NAME.
Restriction Columns
The DBSCHEMA_CATALOGS rowset can be restricted on the columns listed in the following table.
| Column name | Type indicator | Restriction State |
|---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
Optional |