Skip to content

schemata-transact-sql.md

Latest commit

 

History

History
58 lines (52 loc) · 2.94 KB

schemata-transact-sql.md

File metadata and controls

58 lines (52 loc) · 2.94 KB

title: "SCHEMATA (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "09/08/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "system-information-schema-views" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "SCHEMATA_TSQL"
  • "SCHEMATA" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "INFORMATION_SCHEMA.SCHEMATA view"
  • "SCHEMATA view" ms.assetid: 69617642-0f54-4b25-b62f-5f39c8909601 caps.latest.revision: 41 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

SCHEMATA (Transact-SQL)

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

Example
The following example, returns information about the schemas in the master database:

SELECT * FROM master.INFORMATION_SCHEMA.SCHEMATA;

See Also

System Views (Transact-SQL)
Information Schema Views (Transact-SQL)
sys.databases (Transact-SQL)
sys.schemas (Transact-SQL)
sys.syscharsets (Transact-SQL)