To get SQL Server schema id uses function SCHEMA_ID().
Syntax
SCHEMA_ID ( )
SCHEMA_ID ( 'schema name' )
Example
SELECT SCHEMA_ID();
SELECT SCHEMA_ID('dbo');
See also: SCHEMA_ID
To get SQL Server schema id uses function SCHEMA_ID().
SCHEMA_ID ( )
SCHEMA_ID ( 'schema name' )
SELECT SCHEMA_ID();
SELECT SCHEMA_ID('dbo');
See also: SCHEMA_ID