Skip to content

schema-id-transact-sql.md

Latest commit

 

History

History
81 lines (63 loc) · 2.48 KB

schema-id-transact-sql.md

File metadata and controls

81 lines (63 loc) · 2.48 KB

title: "SCHEMA_ID (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/03/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "t-sql|functions" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "SCHEMA_ID"
  • "SCHEMA_ID_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "identification numbers [SQL Server], schemas"
  • "schemas [SQL Server], IDs"
  • "SCHEMA_ID function"
  • "IDs [SQL Server], schemas"
  • "default schema IDs" ms.assetid: c8e34df5-3eea-459f-ae40-050909ce9fda caps.latest.revision: 39 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "On Demand" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

SCHEMA_ID (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

Returns the schema ID associated with a schema name.

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();

B. Returning the schema ID of a named schema

SELECT SCHEMA_ID('dbo');

See Also

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