Database Information Functions

The following functions can be used to get additional information about a database, table, or the database types that are available.

The databaseVersion(<database>) function returns version information about a database server.

The schemaNames(<database>) function returns the names of all of the database schemas (sometimes just called databases) that are available through a connection. Some database adaptors may not support this functionality.

The tableNames(<database>) function returns a list of the names of all of the tables in a database.

The recordInfo(<table>) function returns information about all of the table’s columns and relationships.

The is a record, is a table and is a database operators can be used to test whether a value is a database record or table or a database connection object.

 

This topic was last updated on October 11, 2019, at 11:18:54 AM.

Eggplant icon Eggplantsoftware.com | Documentation Home | User Forums | Support | Copyright © 2019 Eggplant