Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 26 of 79

MySQL SQL Revision Tour — Question 19

Back to all questions
19
Question

Question 16(i)

Differentiate between DROP TABLE, DROP DATABASE.

Answer
DROP TABLEDROP 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;.