3.1.4.2.2.1.3.1.1 Columns

The DBSCHEMA_CATALOGS rowset contains the following columns.

Name	Type	Restriction	Description
CATALOG_NAME	xsd:string	Yes	The catalog name.
DESCRIPTION	xsd:string		The catalog description.
ROLES	xsd:string		A comma-delimited list of roles to which the current user belongs.<194>
DATE_MODIFIED	xsd:dateTime		The date that the catalog was last modified.
COMPATIBILITY_LEVEL	xsd:integer		The compatibility level of the database.
TYPE	xsd:integer		A mask with the following flags: (0x0) Multidimensional. If the other bits are not set, the database is a Multidimensional database. (0x1) TabularMetadata. The Tabular model is built by using Tabular metadata. (0x2) TabularModel. This is a Tabular model, including those built using Tabular or Multidimensional metadata.
VERSION	xsd:integer		A database that uses Tabular Metadata will return the current version of the database. For more details, see [MS-SSAS-T]. Otherwise, the value will be 0.
DATABASE_ID	xsd:string		The ID of the database object.
DATE_QUERIED	xsd:dateTime		Unused.
CURRENTLY_USED	xsd:boolean		Unused.
POPULARITY	xsd:float		A measure of how frequently the database is used. The value is empty for the system tracker.
WEIGHTEDPOPULARITY	xsd:double		A measure of how frequently the database is used, expressed as a fraction with respect to the other databases. The value is empty for the system tracker.
CLIENTCACHEREFRESHPOLICY	xsd:unsignedInt		A hint to the client applications about when their data caches, if any, SHOULD<195> be refreshed after a Refresh command changes the data on the server. The possible values are as follows: 0 – Client applications are notified to refresh their caches only if a user query/interaction needs newer data. -1 (default) – Client applications are notified to allow all background cache refreshes.

The rowset is sorted on CATALOG_NAME.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="ROLES" name="ROLES" type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DATE_MODIFIED" name="DATE_MODIFIED" type="xsd:dateTime" 
                        minOccurs="0" />
           <xsd:element sql:field="COMPATIBILITY_LEVEL" name="COMPATIBILITY_LEVEL" 
                        type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="TYPE" name="TYPE" type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="VERSION" name="VERSION" type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="DATABASE_ID" name="DATABASE_ID" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="DATE_QUERIED" name="DATE_QUERIED" type="xsd:dateTime" 
                        minOccurs="0" />
           <xsd:element sql:field="CURRENTLY_USED" name="CURRENTLY_USED" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="POPULARITY" name="POPULARITY" type="xsd:float" 
                        minOccurs="0" />
           <xsd:element sql:field="WEIGHTEDPOPULARITY" name="WEIGHTEDPOPULARITY" 
                        type="xsd:double" minOccurs="0" />
           <xsd:element sql:field="CLIENTCACHEREFRESHPOLICY" name="CLIENTCACHEREFRESHPOLICY"
                        type="xsd:unsignedInt" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>