xls.columns
Special offer: 50% discount ($1440) for ODataDB Enterprise until May 31, 2024

xls.columns

The xls.columns table allows emulating the INFORMATION_SCHEMA.COLUMNS database table for applications based on REST API.

The table contains the following columns:

Column
ID
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
IS_PRIMARY_KEY
IS_NULLABLE
IS_IDENTITY
IS_COMPUTED
COLUMN_DEFAULT
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
PRECISION
SCALE

The SaveToDB add-in uses this configuration with the following features:

You can start using the REST API without the configuration first and add it later.

You do not need to use this table for database, ODataDB, or DBGate objects as the SaveToDB add-in reads the required configuration from the metadata.