Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |