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 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|