SQL command
DDL: Data Definition Language
| Command | Description |
|---|---|
| create | To create new table or database |
| alter | For alteration |
| truncate | Delete data from table |
| drop | To drop a table |
| rename | To rename a table |
DML: Data Manipulation Language
| Command | Description |
|---|---|
| insert | To insert a new row |
| update | To update existing row |
| delete | To delete a row |
| merge | Merging two rows or two tables |
TCL: Transaction Control Language
| Command | Description |
|---|---|
| commit | to permanently save |
| rollback | to undo change |
| savepoint | to save temporarily |
DCL: Data Control Language
| Command | Description |
|---|---|
| grant | grant permission of right |
| revoke | take back permission. |
DQL: Data Query Language
| Command | Description |
|---|---|
| select | retrieve records from one or more table |
