HEIDENHAIN MANUALPLUS 620 - Page 1630

1630 HEIDENHAIN Technical Manual MANUALplus 620
CREATE TABLE A CREATE TABLE statement creates a new table (new table file). Make sure
that the specified table name does not already exist. The names of the
columns to be inserted are given as a list. The properties of the columns are
read from the configuration. A column configuration for each column name
must be available for this. The column width is determined from the width
configured for a column or from the length of the column name, depending on
which width is larger.
If you enter an asterisk * instead of the list of column names, all the columns
defined in the configuration for this type of table (table extension) will be used.
The ASINCH option is used to specify whether a table is to contain values in
inches. As a result, inch-sensitive columns (defined in the column
configuration) are created as inch columns in the table. If this option is not
specified, the respective columns are created as millimeter columns.
With the LOCALCONFIG option, the properties of the table are stored locally
in the table.
Definition
 create-list := '*' | column-list
 create-table-statement:= CREATE TABLE table '(' create-list ')' [ASINCH]
[LOCALCONFIG]
Examples:
CREATE TABLE TOOL(L,R,R2,DL,DR,DR2,TL,RT,TIME1,TIME2,
CUR_TIME,PLC) ASINCH
CREATE TABLE 'OEM:\TOOL.T' (L,R,R2,DL,DR,DR2,TL,RT,TIME1,TIME2,
CUR_TIME,PLC)
CREATE TABLE *
ALTER TABLE ALTER TABLE modifies the properties of a table. This option enables you to
add or delete columns, and to modify the properties of columns. When you
add columns or modify the properties of columns, the new properties are read
from the configuration. When column properties are modified, the values are
not modified. If the width of the new column is larger than the width of the
previous one, the column is extended to the new width. If the width of the
new column is smaller, however, the column is not changed, so as to avoid
any loss of data.
A new column is inserted in the table at the position which is determined from
the columns defined for the respective type of table (table extension) in the
configuration. The sequence of columns in the table is derived from the
configuration data.
Definition
 alter-table-options:= ADD | MODIFY | DROP
 alter-table-statement:= ALTER TABLE table alter-table-options
'( 'column-list ')'
Examples:
ALTER TABLE TOOL ADD (DOC)
ALTER TABLE 'OEM:\TOOL.T' MODIFY (L)