Query Description Example
CREATE DATABASE CREATE DATABASE myDatabase;
DROP DATABASE Delete database (loss of complete information stored in the database!). DROP DATABASE myDatabase;
SHOW SHOW DATABASES;
CREATE TABLE CREATE TABLE myTable (column1 int, column2 varchar(255),…);
CREATE TABLE, AS New table will be filled with the existing values from the old table. CREATE TABLE newTable AS SELECT column1, column2 FROM oldTable;
DROP TABLE DROP TABLE myTable;
ALTER TABLE Add/delete/modify columns, add/drop constraints on an existing table. ALTER TABLE myTable ADD newColumn varchar(255);