CREATE, SELECT, INSERT, USE, DELETE and DROP are the typical SQL commands for interacting with relational databases. These instructions can be categorised according to their nature into the following classes –
| Sr.No | Command & Description |
|---|---|
| 1 | CREATE Make a new table, table view, or other database structure. |
| 2 | ALTER Changes a table-like existing database object. |
| 3 | DROP Deletes a complete table, table view or other database objects. |
| Sr.No | Command & Description |
|---|---|
| 1 | SELECT Retrieving some records from a few tables |
| 2 | INSERT Creating a record |
| 3 | UPDATE Modifying a few records |
| 4 | DELETE Deleting a few records |
| Sr.No | Command & Description |
|---|---|
| 1 | GRANT Giving the users’ a privilege |
| 2 | REVOKE Takeing back the privileges that a user granted |
|
|
