Sql.Databases

This function retrieves a list of databases from a specified SQL server. It accepts an optional parameter called options, which can be used to customize various settings: - CreateNavigationProperties...

Syntax

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

About

This function retrieves a list of databases from a specified SQL server. It accepts an optional parameter called options, which can be used to customize various settings: - CreateNavigationProperties: A boolean value (true/false) that determines whether navigation properties should be included in the results. The default setting is true. - NavigationPropertyNameGenerator: A function used to generate names for navigation properties. - MaxDegreeOfParallelism: A numerical value that specifies the maximum degree of parallelism for the SQL query. - CommandTimeout: A duration that specifies the maximum time allowed for a query to run before it is canceled. The default value is ten minutes. - ConnectionTimeout: A duration that specifies the maximum time to wait before giving up on establishing a connection to the server. The default value depends on the driver being used. - HierarchicalNavigation: A boolean value (true/false) that determines whether tables should be displayed grouped by their schema names. The def

Explanation

The record parameter is defined with a list of options and corresponding values, such as option1 with value1, option2 with value2, and so on.