Executing SQL statements with the solidDB SQL Editor
You can execute SQL statements in the solidDB SQL Editor (solsql) to perform tasks such as creating, viewing, and deleting tables:
▪ Create a test table
Execute the following statements in solsql:
CREATE TABLE TESTTABLE (VALUE INTEGER, NAME VARCHAR);
COMMIT WORK;
INSERT INTO TESTTABLE (VALUE, NAME) VALUES (31, 'DUFFY DUCK');
COMMIT WORK;
SELECT VALUE, NAME FROM TESTTABLE;
COMMIT WORK;
▪ View a table
Execute the following statement in solsql:
SELECT VALUE, NAME FROM TESTTABLE;
VALUE NAME
----- ----
31 DUFFY DUCK
1 ROWS FETCHED.
COMMIT WORK;
▪ Delete a table
Execute the following statement in solsql:
DROP TABLE TESTTABLE;
COMMIT WORK;
Note To ensure that every database operation gets committed, remember to execute the COMMIT WORK statement.
Go up to