SQL Types

SQL statements are generally categorized into different types based on the tasks each statement can perform.

SQL Type	Commands	Description
Data Definition Language (DDL)	CREATE ALTER DROP TRUNCATE	Statements that define the data and data structure (schema objects).
Data Manipulation Language (DML)	INSERT UPDATE DELETE	Statements that manipulate the data.
Data Control Language (DCL)	GRANT REVOKE	Statements to limit the access on the data.
Transact Control Language (TCL)	COMMIT ROLLBACK SAVEPOINT	Statements to control the transactions in a session.
Data Query Language (DQL)	SELECT	Statements used to view the data.