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.

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