Ddl\dml\dcl\dql

"DML"

DML = Data manipulation Language, manipulation language , commands enable users to query the database and manipulate the computer language of data in existing databases. Specifically, update updates, insert inserts, delete deletes. the main is to manipulate one or more data in the database .  

"DDL"

The database Schema definition language DDL (datadefinition Language) is the language used to describe the real-world entities to be stored in the database. A database schema contains a description definition for all entities in the database. These definitions include structure definitions, operation method definitions, and so on. including Create\alter\drop and so on, mainly used in the table structure, data structure, the relationship between the table and constraints.

"DCL"

DCL (DataControl Language) is a database control language. 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

"DQL"

Dql:data querylanguage SELECT Data Query Language

Select specific usage

Selectselect_list

[Intonew_table]

Fromtable_source

[Wheresearch_condition]

[GROUPBY Group_by_expression]

[Havingsearch_condition]

[Order_expression [ASC | DESC]]

Ddl\dml\dcl\dql