| title |
SCHEMATA (Transact-SQL) |
| description |
SCHEMATA (Transact-SQL) |
| author |
markingmyname |
| ms.author |
maghan |
| ms.date |
09/08/2017 |
| ms.service |
sql |
| ms.subservice |
system-objects |
| ms.topic |
reference |
| ms.custom |
|
| f1_keywords |
|
| helpviewer_keywords |
INFORMATION_SCHEMA.SCHEMATA view |
SCHEMATA view |
|
| dev_langs |
|
| monikerRange |
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]
Returns one row for each schema in the current database. To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.view_name. To retrieve information about all databases in an instance of [!INCLUDEssNoVersion], query the sys.databases (Transact-SQL) catalog view.
| Column name |
Data type |
Description |
| CATALOG_NAME |
sysname |
Name of current database |
| SCHEMA_NAME |
nvarchar(128) |
Returns the name of the schema. |
| SCHEMA_OWNER |
nvarchar(128) |
Schema owner name.
Important: Don't use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view. |
| DEFAULT_CHARACTER_SET_CATALOG |
varchar(6) |
Always returns NULL. |
| DEFAULT_CHARACTER_SET_SCHEMA |
varchar(3) |
Always returns NULL. |
| DEFAULT_CHARACTER_SET_NAME |
sysname |
Returns the name of the default character set. |
Example
The following example, returns information about the schemas in the master database:
SELECT * FROM master.INFORMATION_SCHEMA.SCHEMATA;
System Views (Transact-SQL)
Information Schema Views (Transact-SQL)
sys.databases (Transact-SQL)
sys.schemas (Transact-SQL)
sys.syscharsets (Transact-SQL)