schema-id-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
SCHEMA_ID (Transact-SQL)	SCHEMA_ID returns the schema ID associated with a schema name.	MikeRayMSFT	mikeray	randolphwest	07/18/2024	sql	t-sql	reference	SCHEMA_ID SCHEMA_ID_TSQL	identification numbers [SQL Server], schemas schemas [SQL Server], IDs SCHEMA_ID function IDs [SQL Server], schemas default schema IDs	TSQL	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

SCHEMA_ID (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]

Returns the schema ID associated with a schema name.

Database schemas act as namespaces or containers for objects, such as tables, views, procedures, and functions, that can be found in the sys.objects catalog view.

Each schema has an owner. The owner is a security principal.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

SCHEMA_ID ( [ schema_name ] )

Arguments

schema_name

The name of the schema. schema_name is sysname. If schema_name isn't specified, SCHEMA_ID returns the ID of the default schema of the caller.

Return types

int

NULL is returned if schema_name isn't a valid schema.

Remarks

SCHEMA_ID returns IDs of system schemas and user-defined schemas. SCHEMA_ID can be called in a select list, in a WHERE clause, and anywhere an expression is allowed.

Examples

A. Return the default schema ID of a caller

SELECT SCHEMA_ID();

B. Return the schema ID of a named schema

SELECT SCHEMA_ID('dbo');

Related content

• Metadata Functions (Transact-SQL)
• SCHEMA_NAME (Transact-SQL)
• sys.schemas (Transact-SQL)