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.