Mitsubishi Electric MELSEC iQ-R-R00CPU - Page 999

APPX
Appendix 14 List of Available SQL Commands for CPU Module Database Access Function
997
A
CREATE INDEX
This command creates an index in the specified field of the specified table in the database. Index names must be up to 16
single-byte alphabetical characters and are case sensitive.
■Application example
• To set the index "idx1" to fld2 of table1
CREATE INDEX "idx1" ON "table1" ("fld2");
DROP INDEX
This command deletes the specified index in the database.
■Application example
• To delete the "idx1" index in table1
DROP INDEX "idx1" ON "table1";
EMPTY TABLE
This command deletes all records of the specified table in the database.
■Application example
• To delete all records in table1
EMPTY "table1";
Syntax
CREATE INDEX [index name] ON [table name] (field name);
Syntax
DROP INDEX [index name] ON [table name];
Syntax
EMPTY [table name];