Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DBSCHEMA_CATALOGS Rowset

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

CATALOG_NAME

DBTYPE_WSTR

Optional

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.