xls.columns
The xls.columns table emulates the INFORMATION_SCHEMA.COLUMNS database table for applications using the REST API.
This table includes 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 leverages this configuration with the following features:
You can start using the REST API without the initial configuration and add it later.
This table is not necessary for database, ODataDB, or DBGate objects, as the SaveToDB add-in retrieves the required configuration from the metadata.