SQL Command Essentials: DDL, DML, DCL, TCL ๐
โ DDL (Data Definition Language)
โ CREATE: Make new tables/databases
โ ALTER: Modify table structure
โ DROP: Delete tables/databases
โ TRUNCATE: Remove all data, keep structure
โ DML (Data Manipulation Language)
โ SELECT: Retrieve data
โ INSERT: Add data
โ UPDATE: Change data
โ DELETE: Remove data
โ DCL (Data Control Language)
โ GRANT: Give access rights
โ REVOKE: Remove access rights
โ TCL (Transaction Control Language)
โ COMMIT: Save changes
โ ROLLBACK: Undo changes
โ SAVEPOINT: Mark save point to rollback
โ BEGIN/END TRANSACTION: Start/end transactions
React โค๏ธ for more! ๐
Post #2683
2.67K
- โค 13