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)