SCHEMA_NAME (TSQL Function)

Returns the name of the schema with the specified ID in the current database.

Syntax

SCHEMA_NAME ( [schema_id] )

Arguments

‘schema_id’

optional argument, of type bigint. If omitted, the name of the current schema is returned.

Return Types

Returns varchar.

Remarks

Returns NULL if the schema doesn’t exist in the current database.

Examples

PRINT SCHEMA_NAME();
PRINT SCHEMA_NAME(0);
PRINT SCHEMA_NAME(-123);

The result is:

dbo
dbo
<NULL>