Returns the schema name associated with a schema ID.
SCHEMA_NAME ( [ schema_id ] )
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.
sysname
Returns NULL when schema_id is not a valid ID.
SELECT SCHEMA_NAME();
Functions