LLI Wiki — My Digital Knowledge Base

SQL: command types DML, DDL, DCL and TCL

Memo of the four SQL command families and the statements they group.

A memo on the four main families of SQL commands, handy to classify a statement or to discuss the permissions and transaction handling that go with it.

Family Full name Commands
DML Data Manipulation Language SELECT, INSERT, UPDATE, DELETE
DDL Data Definition Language CREATE, ALTER, DROP, TRUNCATE
DCL Data Control Language GRANT, REVOKE
TCL Transaction Control Language SAVE POINT, ROLLBACK, COMMIT

Screenshots

Infographic of SQL command types: DML, DDL, DCL and TCL

Mastodon LLIMastodon SocialFosstodon