SQL is Structure Query Language which is developed by E.F.Codd.Today almost all Relational Database Management Systems (RDBMS) uses SQL as the standard database language. We can use it to do different types of operations in RDBMS.
SQL COMMAND
SQL provides following data languages to do manipulation in RDBMS.
DDL - Data Definition Language:
| Commands | Description |
| Create | This command creates a new table, a view of a table, or other objects in database |
| Alter | This command modifies an existing database object, such as a table. |
| Drop | This command deletes an entire table, a view of a table or other objects in the database. |
DML - Data Manipulation Language:
| Commands | Description |
| Select | This command retrieves records from one or more tables |
| Insert | This command insert the data into one or more tables |
| Update | This command modify or update the records of a table in database. |
| Delete | This command deletes entire or selected records from the table in the database. |
DCL - Data Control Language:
| Commands | Description |
| Grant | it gives a privilege to user in database |
| Revoke | This command takes back privileges granted from user in database. |
0 Comment(s)