Four Types Of SQL Commands

SQL commands are grouped into four major categories depending on their functionality. They are as follows:

These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.

These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.

These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.

These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.