Introduction to Structured Query Language (SQL) — Formula Sheet

CREATE TABLE tablename( attributename1 datatype constraint, attributename2 datatype constraint, : attributenameN datatype constraint);

ALTER TABLE table_name ADD FOREIGN KEY(attribute name) REFERENCES referenced_table_name (attribute name);

DROP TABLE table_name;

DROP DATABASE database_name;

INSERT INTO tablename VALUES(value 1, value 2,...);

INSERT INTO tablename (column1, column2, ...) VALUES (value1, value2, ...);

UPDATE table_name SET attribute1 = value1, attribute2 = value2, ... WHERE condition;

DELETE FROM table_name WHERE condition;