Technical FAQs

Ask a Question

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

Was this helpful?
What can we do to improve the information ?