The components of SQL are given below.
a. DDL commands ( 3 commands):
1. Create table – Used to create a table.
2. Alter table – Used to modify existing column or add new column to an existing table. There are 2 keywords used ADD and MODIFY.
3. Drop table – Used to remove a table from the memory.
b. DML commands ( 4 commands):
1. Select – Used to select rows from a table. The keyword From is used with this. Where clause is used to specify the condition.
2. Insert – Used to insert new records into a table. So the keyword used is INTO.
3. Delete – Used to delete records in a table.
4. Update – Used to modify the records in a table the keyword used is set.
c. DCL (Data Control Language) commands:
1. Grant – It grants permission to the users to the database
2. Revoke – It withdraws user’s rights given by using Grant command
