How are SQL commands classified?

SQL Commands can be classified in following three ways:

  1. Data Definition Language (DDL) Commands – command that allow you to perform task related to data definition. For example CREATE, ALTER, DROP
  2. Data Manipulation Language (DML) Commands – Commands that allow you to perform data manipulation. For example SELECT, INSERT, UPDATE, DELETE
  3. Transaction Control Language (TCL) Commands – Commands that allow you to manage and control the transactions. For example COMMIT, ROLLBACK
error: Content is protected !!