Skip to content

Create Table

Creates a table.

Permissions

Command KindNeeded User Kind
WriteAdmin, Sys

Parameters

NameTypeDescriptionRequiredDefaultValues
Dimensionarray of stringName of the dimension ([Dimension]).yes
TablestringName of the table ([Table]).yes
Caption1stringCaption 1no
Caption2stringCaption 2no
Caption3stringCaption 3no
Caption4stringCaption 4no
Caption5stringCaption 5no
Caption6stringCaption 6no
Caption7stringCaption 7no
Caption8stringCaption 8no
Caption9stringCaption 9no
Caption10stringCaption 10no
Doublearray of stringName of a number field ([Field]=.no
Stringarray of stringName of a text field ([Field]).no

Result

NameTypeDescription
TablestringName of the table.
Caption1stringCaption 1
Caption2stringCaption 2
Caption3stringCaption 3
Caption4stringCaption 4
Caption5stringCaption 5
Caption6stringCaption 6
Caption7stringCaption 7
Caption8stringCaption 8
Caption9stringCaption 9
Caption10stringCaption 10
RecordsnumberNumber of records of the table.
CellsnumberNumber of cells (records * number and text fields) of the table.
SubtablesintegerNumber of subtables of the table.
TablecalculationsintegerNumber of tablecalculations of the table.
VisualbooleanIf 'True' the table has a visual script.
DerivationbooleanIf 'True' the table is linked with another table as a derivation.
SourceLinksintegerNumber of tables to which this table sends data.
DestinationLinksintegerNumber of tables from which this table gets data.
PermissionstringTable permissions of the actual user.

Code

text
CREATE TABLE
DIMENSION=[string, Multiple, Needed]
TABLE=[string, Needed]
CAPTION1=[string]
CAPTION2=[string]
CAPTION3=[string]
CAPTION4=[string]
CAPTION5=[string]
CAPTION6=[string]
CAPTION7=[string]
CAPTION8=[string]
CAPTION9=[string]
CAPTION10=[string]
DOUBLE=[string, Multiple]
STRING=[string, Multiple]