Differentiate between: DROP TABLE, DROP DATABASE, DROP TABLE, DROP clause of ALTER TABLE.

Q. Differentiate between:

(i) DROP TABLE, DROP DATABASE

(ii) DROP TABLE, DROP clause of ALTER TABLE.

Answer =

(i)
drop table = it delete  table or relation from database
Drop  database = it delete the database from MYSQL server.

(ii)
drop table = it delete  table or relation from database
DROP clause of ALTER TABLE = it delete a particular column or filed from table or relation.