Data Definition Language (DDL):

  • Data management SQL commands around database structures
  • CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME

Data Manipulation Language (DML):

  • SQL Commands around data manipulation
  • SELECT, INSERT, UPDATE, DELETE

Data Control Language (DCL):

  • grating rights and permissions to others
  • GRANT, REVOKE