InfoTables
This is a system table that provides a list of tables.
View-Specific Information
Select
The server uses the CMS API to process WHERE clause conditions built with the following columns and operators:- Id supports the '=' comparison operator.
The server processes other filters client-side within the server.
For example, the following queries are processed server-side:
SELECT * FROM InfoTables WHERE Id = 7272349
UPDATE
UPDATE InfoTables SET Label = 'ServerSideFilters1' WHERE Id = 7284337;
Columns
| 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. |