SQL commands can be classified into groups based on their nature:
DDL - Data Definition Language:
| Command | Description |
|---|---|
| Create | Creates a new table, a view of a table, or other object in database |
| Alter | Modifies an existing database object, such as a table. |
| Drop | Deletes an entire table, a view of a table or the database. |
DML - Data Manipulation Language:
| Command | Description |
|---|---|
| Select | Retrieves certain records from one or more tables |
| Insert | Creates a record |
| Update | Modifies records |
| Delete | Deletes records |
DCL - Data Control Language:
| Command | Description |
|---|---|
| Grant | Gives a privilege to user |
| Revoke | Takes back privileges granted from user |