Metadata SCHEMA_NAME SQL function

1. Usage of SCHEMA_NAME

SQL Server Query 1

            
 SELECT SCHEMA_NAME() AS 'Schema_Name'  

 UNION ALL  

 SELECT SCHEMA_NAME(1) AS 'Schema_Name';    

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new SCHEMA_NAME(), "Schema_Name")  

     .UnionAll(new SqlQueryBuilder()  

         .Select()  

         .Column(new SCHEMA_NAME(1), "File_ID")  

     )  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT SCHEMA_NAME() AS Schema_Name
UNION ALL
SELECT SCHEMA_NAME(@pMAIN_2507200152182713160) AS File_ID;


            
        

Parameters (If used)

Query Results 1: