Sql.Database

Returns a table containing SQL tables located on a SQL Server instance database.

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

Arguments

Argument

Description

server

The name of the SQL Server instance.

datab

The database in the SQL Server instance.

optional options

An options record to control the behavior of this function.

options Settings

Setting

Description

MaxDegreeOfParallelism as number or integer

Sets the value of the "maxdop” query clause in the generated SQL query.

CreateNavigationProperties as logical

Sets whether to generate navigation properties on the returned values. Default is true.

NavigationPropertyNameGenerator as function

Provides a function that is used for the creation of names for navigation properties.

Example

Sql.Database("localhost", "Northwind")  

Applies To: Excel 2013, Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language