Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the schema ID associated with a schema name.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
SCHEMA_ID( [ schema_name ] )
Arguments
| Term | Definition |
|---|---|
schema_name |
Is the name of the schema. schema_name is a sysname. If schema_name is not specified, SCHEMA_ID will return the ID of the default schema of the caller. |
Return Types
int
NULL will be returned if schema_name is not a valid schema.
Remarks
SCHEMA_ID will return 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. Returning the default schema ID of a caller
select schema_id();
GO
B. Returning the schema ID of a named schema
USE AdventureWorks;
GO
SELECT SCHEMA_ID('HumanResources');
GO
See Also
Reference
Metadata Functions (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
sys.schemas (Transact-SQL)