Informix.Database
The function retrieves a list of SQL tables and views found in an Informix database located on the server named server within the database instance named database. The port can be specified alongside ...
Informix.Database(server as text, database as text, optional options as nullable record) as table.
The function retrieves a list of SQL tables and views found in an Informix database located on the server named server within the database instance named database. The port can be specified alongside the server by using a colon. A set of optional parameters, options, can be provided to customize the behavior of the function:
- CreateNavigationProperties: By setting this logical (true/false) parameter, users can specify whether or not to generate navigation properties in the returned data. The default value is true.
- NavigationPropertyNameGenerator: This parameter allows users to define a function that will be used to name the navigation properties.
- Query: Users can provide a native SQL query to fetch data. If the query results in multiple sets of data, only the first set will be returned.
- CommandTimeout: This parameter sets a time limit for how long the server-side query can run before it is terminated. The default duration is ten minutes.
- ConnectionTimeout: Users can define a duration that determine