Command Categories

• SQL commands are divided roughly into two categories:

  • DDL: Data Definition Language
    • Handles creation, deletion and modifications of tables and column data types.
    • CREATE, ALTER and DROP are examples
  • DML: Data Manipulation Language
    • Handles retrieval, storage or processing of record information.
    • SELECT, DELETE, INSERT and UPDATE