2019-06-19 21:34:45

DDL (Data Definition Language)

  • CREATE
  • DROP
  • ALTER
  • TRUNCATE
  • COMMENT
  • RENAME

DML (Data Manipulation Language)

  • SELECT
  • INSERT
  • UPDATE
  • DELETE

DCL (Data Control Language)

  • GRANT - Gives users access privileges to database objects.
  • REVOKE - Withdraw users access privileges given by using the GRANT command.

TCL (Transaction Control Language)

  • COMMIT - commits a transaction.
  • ROLLBACK - Rollbacks a transaction in case of error occurs.
  • SAVEPOINT - Sets a savepoint within a transaction.
  • SET TRANSACTION - Specify characteristics for the transaction.
Copyright © 2025 delaney. All rights reserved.