Question 8(i)Differentiate between DROP TABLE, DROP DATABASE.

Question

Accepted Answer

DROP TABLEDROP DATABASEThis command is used to delete a specific table from the database along with all its data, indexes, triggers, and constraints.This command is used to delete an entire database including all its tables, views, stored procedures, triggers, and other objects.The syntax is : DROP TABLE table_name;.The syntax is : DROP DATABASE database_name;.

DROP TABLE	DROP DATABASE
This command is used to delete a specific table from the database along with all its data, indexes, triggers, and constraints.	This command is used to delete an entire database including all its tables, views, stored procedures, triggers, and other objects.
The syntax is : `DROP TABLE table_name;`.	The syntax is : `DROP DATABASE database_name;`.

Table Creation and Data Manipulation Commands — Question 8

Question 8(i)