SCHEMATA

Transact-SQL Reference

Transact-SQL Reference

SCHEMATA

Contains one row for each database that has permissions for the current user. The INFORMATION_SCHEMA.SCHEMATA view is based on the sysdatabases, sysconfigures, and syscharsets system tables.

To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA view_name.

Column name Data type Description
CATALOG_NAME sysname Name of the database where the current user has permissions.
SCHEMA_NAME nvarchar(128) Returns the name of the schema owner of object.
SCHEMA_OWNER nvarchar(128) Schema owner name.
DEFAULT_CHARACTER_SET_CATALOG varchar(6) Returns master, indicating the database where the default character set is defined.
DEFAULT_CHARACTER_SET_SCHEMA varchar(3) Returns DBO, indicating the name of the default character set owner.
DEFAULT_CHARACTER_SET_NAME sysname Returns the name of the default character set.

See Also

syscharsets

sysconfigures

sysdatabases