Executing SQL statements with solidDB® SQL Editor (solsql)

Administrator Guide : Using solidDB® data management tools : solidDB® SQL Editor (solsql) : Executing SQL statements with solidDB® SQL Editor (solsql)

Executing SQL statements with solidDB^® SQL Editor (solsql)

To issue SQL statements with solsql, the statements must be terminated by a semicolon (;).

Examples

CREATE TABLE TESTTABLE (VALUE INTEGER, NAME VARCHAR);
COMMIT WORK;
INSERT INTO TESTTABLE (VALUE, NAME) VALUES (31, 'DUFFY DUCK');
SELECT VALUE, NAME FROM TESTTABLE;
COMMIT WORK;
DROP TABLE TESTTABLE;
COMMIT WORK;