HEIDENHAIN TNC 620 Programming Station

Programming Qparameters | Accessing tables with SQL statements
SQL EXECUTE
SQL EXECUTE can be used in conjunction with various SQL
instructions.
The following SQL instructions are used in the SQL command
SQL EXECUTE.
Instruction Function
SELECT Select data
CREATE
SYNONYM
Create synonym (replace long path names
with short names)
DROP SYNONYM Delete synonym
CREATE TABLE Generate a table
COPY TABLE Copy table
RENAME TABLE Rename table
DROP TABLE Delete a table
INSERT Insert table rows
UPDATE Update table rows
DELETE Delete table rows
ALTER TABLE Add table columns using ADD
Delete table columns using DROP
RENAME COLUMN Rename table columns
Example for the SQL EXECUTE command
Remarks:
The gray arrows and associated syntax do not directly belong to
the SQL EXECUTE command
Black arrows and associated syntax indicate internal processes of
SQL EXECUTE
9
HEIDENHAIN | TNC620 | Klartext Programming User's Manual | 01/2022
335