| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SCHEMATA (Transact-SQL) |
SCHEMATA (Transact-SQL) |
markingmyname |
maghan |
09/08/2017 |
sql |
system-objects |
reference |
|
|
|
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]
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)