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

MySQL SQL Revision Tour — Question 25

Back to all questions
25
Question

Question 21

What is the purpose of DROP TABLE command in MySql ? How is it different from DELETE command ?

Answer

The DROP TABLE command in MySql is used to permanently delete an entire table from the database, including its structure, data, indexes, triggers, and constraints. The DELETE command, on the other hand, is used to remove specific rows or all rows from a table, leaving the table structure intact.