1.DDL (data definition Language) Database Definition language statements is used to define the databases structure or schema.
DDL is one of the four functions of SQL language.
A three-level structure for defining a database, including external, conceptual, internal, and inter-image, defining constraints such as data integrity, security controls, and more
DDL does not require a commit.
CREATE
Alter
DROP
TRUNCATE
COMMENT
RENAME
2.DML (data manipulation Language) Manipulation language statements is used for managing data within schema objects.
provided by the DBMS for use by a user or programmer to implement operations on data in a database.
DML is divided into two classes: interactive DML and embedded DML.
depending on the level of the language, DML can be divided into procedural DML and non-procedural DML two species.
A commit is required.
SELECT
INSERT
UPDATE
DELETE
MERGE
Pager
EXPLAIN PLAN
LOCK TABLE
3.DCL (Data Control Language) database Control Language Authorization, role control, etc.
Grant Authorization
REVOKE Cancel Authorization
4.tcl (Transaction control Language) transaction Control Language
rollback rollback
sql is divided into four parts:
(1) data definition. (SQL DDL) to define the creation and undo operations of SQL schemas, basic tables, views, and indexes.
(2) data manipulation. (SQL DML) data manipulation is divided into two categories: Data query and Data update. Data update is divided into three kinds of operations, inserting, deleting, and modifying.
(3) data control. Includes authorization for basic tables and views, description of integrity rules, transaction control, and so on.
(4) rules for the use of Embedded SQL. involves embedding rules that SQL statements use in the host language program.
The DDL,DML,DCL,TCL inside SQL Server