Issuing SQL statements with solidDB® SQL Editor

Getting Started : Verifying your solidDB® installation : Issuing SQL statements with solidDB® SQL Editor

Issuing SQL statements with solidDB^® SQL Editor

You can issue SQL statements in the solidDB^® SQL Editor. This section shows an example of creating, viewing, and deleting a test table.

Procedure

1 Create a table by issuing the following commands 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;

2 View the table with the following command:

SELECT VALUE, NAME FROM TESTTABLE;

    VALUE NAME
    ----- ----
       31 DUFFY DUCK
1 ROWS FETCHED.

COMMIT WORK;

3 Delete the table with the following command:

DROP TABLE TESTTABLE;
COMMIT WORK;

Tip: To ensure that every database operation gets committed, remember to issue the COMMIT WORK statement.