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

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

ENCRYPTION_LEVEL<204>

xsd:string

The encryption schema used for this database’s secrets. The possible values are as follows:

  • "Analysis Services 2019"

  • "Analysis Services 2022"

  • "Analysis Services 2022 CU"

CRYPTOKEY_UPDATED<205>

xsd:dateTime

The date that the database encryption key was created or regenerated.

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:element sql:field="ENCRYPTION_LEVEL" name="ENCRYPTION_LEVEL"
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CRYPTOKEY_UPDATED" name="CRYPTOKEY_UPDATED"
                        type="xsd:dateTime" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>
  • Last updated on