Applies To: SQL Server 2016 Preview

Identifies the physical attributes associated with catalogs accessible from the database management system (DBMS).

The DBSCHEMA_CATALOGS rowset contains the following columns.

Column nameType indicatorLengthDescription
CATALOG_NAMEDBTYPE_WSTR255The catalog name. Cannot be null.
DESCRIPTIONDBTYPE_WSTRA human-readable description of the table.
ROLESDBTYPE_WSTRA 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_MODIFIEDDBTYPE_DBTIMESTAMPThe 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 nameType indicatorRestriction State

OLE DB Schema Rowsets

Community Additions