Teradata.Database

This function retrieves a list of SQL tables and views from a Teradata database located on a specified server. The port number can be indicated by appending a colon after the server address. Users can...

Syntax

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

About

This function retrieves a list of SQL tables and views from a Teradata database located on a specified server. The port number can be indicated by appending a colon after the server address. Users can also provide optional inputs, known as options, to customize the behavior of the function: - CreateNavigationProperties: A boolean value (true/false) that determines whether navigation properties should be included in the output (default is true). - NavigationPropertyNameGenerator: A function responsible for naming the generated navigation properties. - Query: A native SQL query used to fetch data. If the query produces multiple result sets, only the first set will be returned. - CommandTimeout: A duration specifying the maximum running time for a server-side query before it's canceled. The default timeout is set to ten minutes. - ConnectionTimeout: A duration specifying how long the system should wait before giving up on establishing a connection with the server. The default timeout may vary depending on the

Explanation

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