Is SQL Data Definition Language (DDL) supported in the Free SQL Request window of the FactoryCast HMI Database service?



The Free SQL Request window is designed to process basic SQL Data Definition Language (DDL) commands. Free SQL Request window permits the Data Definition Language (DDL) SQL commands that create or delete database tables, define indexes (keys), specify links between tables, and impose constraints between database tables.
The most important SQL Data Definition Language statements that can be processed in the Free SQL Request window are:

* CREATE TABLE - creates a new database table
* ALTER TABLE - alters (changes) a database table
* DROP TABLE - deletes a database table
* CREATE INDEX - creates an index (search key)
* DROP INDEX - deletes an index

Legacy KB System (APS) Data: RESL186039 V1.0, Originally authored by DaSo on 07/02/2007, Last Edited by DaSo on 07/02/2007
Related ranges: Modicon Quantum