Sql.Database

Retrieve a list of tables, views, and stored functions from a SQL Server database located on a specified server. The port number can be indicated alongside the server address using a colon or comma. A...

Syntax

Sql.Database(server as text, database as text, optional options as nullable record) as table.

About

Retrieve a list of tables, views, and stored functions from a SQL Server database located on a specified server. The port number can be indicated alongside the server address using a colon or comma. A set of optional parameters, known as options, can be provided to customize the behavior: - Query: Input a SQL query to fetch data. If the query yields multiple result sets, only the first one will be returned. - CreateNavigationProperties: Set to true or false to determine whether navigation properties should be generated in the output (default is true). - NavigationPropertyNameGenerator: Define a function to assign names to navigation properties. - MaxDegreeOfParallelism: Specify a numerical value to control the "maxdop" query clause in the generated SQL statement. - CommandTimeout: Set a time limit for how long the server-side query can run before being terminated. The default duration is ten minutes. - ConnectionTimeout: Establish a duration to wait before abandoning an attempt to establish a connection wit

Explanation

The record parameter should be defined in the format [option1 = value1, option2 = value2...] or [Query = "select ..."].