- DML (Data Manipulation language): They are select, UPDATE, INSERT, DELETE, just like its name, these 4 commands are the languages used to manipulate the data in the database
- DDL (data Definition Language): DDL is more than DML, the main command has create, ALTER, drop, etc., DDL is mainly used in the definition or Change tables (table) structure, data types, table links and constraints, such as initialization work, Most of them use when building tables
- DCL (Data Control Language): is a database control function. is a statement that is used to set or change permissions for a database user or role, including (Grant,deny,revoke, etc.) statements. By default, only people such as Sysadmin,dbcreator,db_owner or db_securityadmin have the power to execute the DCL
- Tcl-transaction control Language: Transaction control Language, COMMIT-save completed work, SavePoint-set savepoint in transaction, can roll back here, ROLLBACK-rollback, set Transaction- Change transaction options
Reference:
1, http://blog.51cto.com/jim123/1979202
2, https://www.bysocket.com/?p=1174
3, 69666318
4, 4248685
The difference and understanding of database DDL, DML and DCL