| title |
SCHEMATA (Transact-SQL) | Microsoft Docs |
| ms.custom |
|
| ms.date |
03/15/2017 |
| ms.prod |
sql-non-specified |
| ms.reviewer |
|
| ms.suite |
|
| ms.technology |
|
| ms.tgt_pltfrm |
|
| ms.topic |
language-reference |
| f1_keywords |
|
| dev_langs |
|
| helpviewer_keywords |
INFORMATION_SCHEMA.SCHEMATA view |
SCHEMATA view |
|
| ms.assetid |
69617642-0f54-4b25-b62f-5f39c8909601 |
| caps.latest.revision |
41 |
| author |
BYHAM |
| ms.author |
rickbyh |
| manager |
jhubbard |
[!INCLUDEtsql-appliesto-ss2008-all_md]
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 ** Do not use INFORMATION_SCHEMA views to determine the schema 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. |
System Views (Transact-SQL)
Information Schema Views (Transact-SQL)
sys.databases (Transact-SQL)
sys.schemas (Transact-SQL)
sys.syscharsets (Transact-SQL)