This is a system table that provides a list of table columns.

View-Specific Information

Select

The connector uses the CMS API to process WHERE clause conditions built with the following columns and operators:

• TableId supports the '=' comparison operator.

The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

    SELECT * FROM InfoColumns WHERE TableId = 7272349

UPDATE

    UPDATE InfoColumns SET Name = 'colnum', Label = 'ColNumber', Type = 'NUMBER', Options = '' WHERE Id = 2 AND TableId = 7284337

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Bigint	True	Column Id.
TableId [KEY]	Bigint	True	Table Id.
Name	String	False	Name of column.
Label	String	False	Label of column.
Type	String	False	Column type.
Options	String	False	A list of options for select and multiselect columns. Aggregated JSON value.
ForeignIdsById	String	False	The Id of foreign row.
ForeignIdsByName	String	False	The name of the foreign row.