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