SCHEMATA (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

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 SQL Server, 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;

See Also

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