SQL Commands can be classified in following three ways:
- Data Definition Language (DDL) Commands – command that allow you to perform task related to data definition. For example CREATE, ALTER, DROP
- Data Manipulation Language (DML) Commands – Commands that allow you to perform data manipulation. For example SELECT, INSERT, UPDATE, DELETE
- Transaction Control Language (TCL) Commands – Commands that allow you to manage and control the transactions. For example COMMIT, ROLLBACK