January 2012 8.12 Tables 1631
COPY TABLE COPY TABLE copies the table into a new table. Make sure that the name of
the target file does not already exist. The name stored internally will be
modified accordingly. It is possible to specify logical table names.
Definition
copy-table-statement:= COPY TABLE table TO table
Examples:
COPY TABLE TOOL TO 'OEM:\TOOL.T'
COPY TABLE 'OEM:\TOOL.T' TO 'OEM:\TOOL2.T'
DROP TABLE DROP TABLE deletes an existing table file. If a logical table name is specified,
the file identified by the name will be deleted.
Definition
drop-table-statement:= DROP TABLE table
Examples:
DROP TABLE TOOL
DROP TABLE 'OEM:\TOOL.T'
RENAME COLUMN RENAME COLUMN changes the name of an existing column. The properties
of the column are not changed. If the configuration of the table is stored locally
in the table, the name of the column is also changed in the respective
configuration data.
Definition
rename-column-statement:= RENAME COLUMN table '(' column-list ')' TO
'(' column-list ')'
Example:
RENAME COLUMN TOOL ( DR2 ) TO ( DIR )
CREATE SYNONYM CREATE SYNONYM creates a new logical table name. It is not necessary that
the table file identified by the logical name already exists.
Definition
create-synonym-statement:= CREATE SYNONYM table-name FOR
table-literal
Example:
CREATE SYNONYM OUTIL FOR 'OEM:\TOOL.T'
To Next Page
Loading...
