Understanding the xls.columns Configuration Table
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.