SQL Basics | DCL: Data Control Language
DCL (Data Control Language) is a language for controlling data. It is used to define data security, integrity, recovery, and concurrency control.
- COMMIT: Applies the result of a transaction
- ROLLBACK: Cancels a transaction and restores it to its original state
- GRANT: Grants privileges to a user
- REVOKE: Revokes user privileges
TCL
Some sources separate COMMIT and ROLLBACK, which are commands that control transactions within DCL, and refer to them as TCL (Transaction Control Language).