Differentiate between the following commands: a) ALTER and UPDATE b) DELETE and DROP

Q. Differentiate between the following commands:
a) ALTER and UPDATE
b) DELETE and DROP

Answer :-

(a)

ALTER :-

i) It is used to change/update the Structure of table.

ii) It is DDL Command.

iii) Example :- Alter table Student add column Name char(40);

UPDATE :- 

i) It is used to update/modify the data or records of a table.

ii) It is DML Command.

iii) Example :- Update Student set Class = 12 ;

 

(b)

DELETE :-

i) It is used to delete data of table only.

ii) It is DML Command.

iii) Example :- Delete from Student ;

DROP :-

i) It is used to delete database or table from database

ii) It is DDL Command.

iii) Example :- Drop Table Student.