Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 37 of 91

Relational Database and SQL — Question 15

Back to all questions
15
Question

Question 15

Which of the following commands will delete the table from MYSQL database?

  1. DELETE TABLE
  2. DROP TABLE
  3. REMOVE TABLE
  4. ALTER TABLE
Answer

DROP TABLE

Reason — The DROP TABLE command in SQL will delete the table from the MYSQL database. Once this command is executed, the table and all its associated data are removed from the database. After dropping the table, the table name is no longer recognized within the database system, and no further commands can be executed on that object.