SQL Syntax

SQL’s syntax comprises several types of statements that allow you to perform various commands and operations.

The main components are:

• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Transaction Control Language (TCL)

Data Definition Language

The statements part of the Data Definition Language syntax are:

• The CREATE statement
• The ALTER statement
• The DROP statement
• The RENAME statement
• The TRUNCATE statement

Data Manipulation Language

The statements part of the Data Manipulation Language syntax are:

• The SELECT statement
• The INSERT statement
• The UPDATE statement
• The DELETE statement

Data Control Language

The Data Control Language is a syntax that consists of only two statements:

• The GRANT statement
• The REVOKE statement These statements allow us to manage the rights that users have in a database.

Transaction Control Language

The Transaction Control Language is a syntax that contains four statements:

• The COMMIT statement
• The ROLLBACK statement
• The SAVEPOINT statement
• The SET TRANSACTION statement