InfoTables

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

View-Specific Information

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

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

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

    SELECT * FROM InfoTables WHERE Id = 7272349

    UPDATE InfoTables SET Label = 'ServerSideFilters1' WHERE Id = 7284337;


Name	Type	ReadOnly	Description
Id [KEY]	Bigint	True	The Id of the table.
Name	String	False	The name of the table.
Label	String	False	The label of the table.
UseForPages	Boolean	False	Specifies whether the table can be used for creating dynamic pages.
AllowPublicApiAccess	Boolean	False	Specifies whether the table can be read publicly without authorization.
AllowChildTables	Boolean	False	Specifies whether child tables can be created.
Archived	Boolean	True	Specifies whether the table is archived.
CreatedBy	Bigint	True	Id of the user who created.
CreatedAt	Datetime	True	The date time when it was created.
UpdatedAt	Datetime	True	The last date time when it was updated.
PublishedAt	Datetime	True	The last date time when it was published.