xls.columns

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.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.