What are DDL, DML, DQL, DCL and TCL in SQL?
What are DDL, DML, DQL, DCL and TCL in SQL?
SQL statements are grouped into sublanguages by what they do: define structure (DDL), change data (DML), read data (DQL), control access (DCL) and control transactions (TCL).
| Group | Purpose | Typical statements |
|---|---|---|
| DDL (Data Definition) | Create and change objects | CREATE, ALTER, DROP, TRUNCATE, RENAME |
| DML (Data Manipulation) | Change rows | INSERT, UPDATE, DELETE, MERGE |
| DQL (Data Query) | Read rows | SELECT |
| DCL (Data Control) | Permissions | GRANT, REVOKE (SQL Server also has DENY) |
| TCL (Transaction Control) | Transactions | BEGIN / START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT |
CREATE TABLE products (id INT PRIMARY KEY, name VARCHAR(100), price DECIMAL(10,2)); -- DDL
Đăng nhập để tham gia thảo luận cùng mọi người.
Chưa có bình luận nào
Hãy là người đầu tiên chia sẻ suy nghĩ của bạn.