Metadata SCHEMA_ID SQL function

1. Usage of SCHEMA_ID

SQL Server Query 1

            
 SELECT SCHEMA_ID() AS 'Schema_ID'  

 UNION ALL  

 SELECT SCHEMA_ID('dbo') AS 'Schema_ID';

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new SCHEMA_ID(), "Schema_ID")  

     .UnionAll(new SqlQueryBuilder()  

         .Select()  

         .Column(new SCHEMA_ID("dbo"), "Schema_ID")  

     )  

     .Build();

Query build by SqlQueryBuilder 1

            
SELECT SCHEMA_ID() AS Schema_ID
UNION ALL
SELECT SCHEMA_ID(@pMAIN_2507192013279538150) AS Schema_ID;

Parameters (If used)

Name	Value
@pMAIN_2507192013279538150	dbo

Query Results 1:

	Schema_ID
1	5
2	1