xls.columns
The xls.columns table serves as an equivalent to the INFORMATION_SCHEMA.COLUMNS table for applications using the REST API.
This 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 field settings to enable the following features:
You can start using the REST API without any initial configuration and set it up later.
Note that this table is not applicable to database objects, nor to ODataDB and DBGate objects, as the SaveToDB add-in retrieves all necessary data from the metadata.