DBSCHEMA_CATALOGS Rowset
Identifies the physical attributes associated with catalogs accessible from the database management system (DBMS).
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.
