Appearance
Show Tables
Shows the tables.
Permissions
| Command Kind | Needed User Kind |
|---|---|
| Read | All |
Parameters
| Name | Type | Description | Required | Default | Values |
|---|---|---|---|---|---|
| Find | string | Value to search for in name and captions. | no | ||
| MaxRecords | integer | Maximum number of records to be returned. The default value is 500000. | no | 500000 | |
| Sort | string | Sorts the output by name or caption ([Field].[Caption1]). The field can be [Table]/[Name], [Caption1], [Caption2], [Caption3], [Caption4], [Caption5], [Caption6], [Caption7], [Caption8], [Caption9], [Caption10]. Sort can be Ascending (Asc) or Descending (Desc), e.g. [Caption1].[Ascending] | no |
Result
| Name | Type | Description |
|---|---|---|
| Table | string | Name of the table. |
| Caption1 | string | Caption 1 |
| Caption2 | string | Caption 2 |
| Caption3 | string | Caption 3 |
| Caption4 | string | Caption 4 |
| Caption5 | string | Caption 5 |
| Caption6 | string | Caption 6 |
| Caption7 | string | Caption 7 |
| Caption8 | string | Caption 8 |
| Caption9 | string | Caption 9 |
| Caption10 | string | Caption 10 |
| Records | number | Number of records of the table. |
| Cells | number | Number of cells (records * number and text fields) of the table. |
| Subtables | integer | Number of subtables of the table. |
| Tablecalculations | integer | Number of tablecalculations of the table. |
| Visual | boolean | If 'True' the table has a visual script. |
| Derivation | boolean | If 'True' the table is linked with another table as a derivation. |
| SourceLinks | integer | Number of tables to which this table sends data. |
| DestinationLinks | integer | Number of tables from which this table gets data. |
| Permission | string | Table permissions of the actual user. |
Code
text
SHOW TABLES
FIND=[string]
MAXRECORDS=[integer, default=500000]
SORT=[string]