SCHEMA_NAME (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 the schema name associated with a schema ID.

Transact-SQL syntax conventions

Syntax

SCHEMA_NAME ( [ schema_id ] )  

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Arguments

Term Definition
schema_id The ID of the schema. schema_id is an int. If schema_id is not defined, SCHEMA_NAME will return the name of the default schema of the caller.

Return Types

sysname

Returns NULL when schema_id is not a valid ID.

Remarks

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

Examples

A. Returning the name of the default schema of the caller

SELECT SCHEMA_NAME();  

B. Returning the name of a schema by using an ID

SELECT SCHEMA_NAME(1);  

See Also

Expressions (Transact-SQL)
SCHEMA_ID (Transact-SQL)
sys.schemas (Transact-SQL)
sys.database_principals (Transact-SQL)
Metadata Functions (Transact-SQL)
WHERE (Transact-SQL)