InfoTables
This is a system table that provides a list of tables.
View-Specific Information
Select
The 本製品 uses the CMS API to process WHERE clause conditions built with the following columns and operators:- Id supports the '=' comparison operator.
The 本製品 processes other filters client-side within the 本製品.
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. |