SQL Learning Path - Creating and Dropping Tables Discussion

One fun tip; You can have multiple statements in the Query editor and hi-light the statement that you want to run and it will only run that statement.

For example, you could have both statements in the 'SQL Query' window and just hi-light (select) the query you want to run. The SQL engine will ignore the un-selected query.

: )

CREATE TABLE products (
product_name VARCHAR(40),
product_code INTEGER
);

DROP TABLE products;