Question

8. Differentiate between :
(1) DROP TABLE, DROP DATABASE​

Answer 1

Answer:

DROP DATABASE drops all tables in the database and deletes the database. ... To use DROP DATABASE, you need the DROP privilege on the database. DROP SCHEMA is a synonym for DROP DATABASE . Important: When a database is dropped, user privileges on the database are not automatically dropped.

Drop a Table. The drop table command is used to delete a table and all rows in the table. ... Deleting all of the records in the table leaves the table including column and constraint information. Dropping the table removes the table definition as well as all of its rows.

Answer 2

DROP DATABASE drops all tables in the database and deletes the database. ... ... Dropping the table removes the table definition as well as all of its rows.