Metadata FILE_ID SQL function

1. Usage of FILE_ID

SQL Server Query 1

            
 SELECT FILE_ID('Northwind') AS 'File ID';

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new FILE_ID("Northwind"), "File_ID")  

     .Build();

Query build by SqlQueryBuilder 1

            
SELECT FILE_ID(@pMAIN_2507200128177155430) AS File_ID;

Parameters (If used)

Name	Value
@pMAIN_2507200128177155430	Northwind

Query Results 1:

	File_ID
1	0