The program will pause to accept an SQL command.
CREATE TABLE newtab (col1 CHAR(30), col2 CHAR(11))The program will pause to accept an SQL command.
GRANT ALL PRIVILEGES ON newtab TO PUBLIC
The program will pause to accept an SQL command.
CREATE UNIQUE INDEX newtab_index ON newtab (col1)
When naming columns and tables, make sure to use underscores ("_"), not hyphens ("-"), or a syntax error will result.
The above entries will create a new table and grant access permission to everyone. If you want to delete the table you created, enter the following command:
DROP TABLE newtab