SQL 2 - Data Definition Language
Here, you will see how to create a table, add fields, change tables and the fields as well as getting rid of both. The commands covered are:-
CREATE TABLE
SHOW TABLES
ALTER TABLE ADD COLUMN
ALTER TABLE MODIFY
ALTER TABLE RENAME
ALTER TABLE DROP
DROP TABLE