Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
SCHEMA_NAME (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database in Microsoft Fabric
Returns the schema name associated with a schema ID.
👁 Image
Transact-SQL syntax conventions
Syntax
SCHEMA_NAME ( [ schema_id ] )
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)
Feedback
Was this page helpful?