There are five types of commands in SQL based on the type of operation they perform:
- Data Definition Language – CREATE, ALTER, DROP
- Data Modification Language – INSERT, UPDATE, DELETE
- Data Control Language – GRANT, REVOKE
- Transaction Control Language – COMMIT, ROLLBACK, SAVEPOINT
- Data Query Language – SELECT