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

MySQL SQL Revision Tour — Question 20

Back to all questions
20
Question

Question 16(ii)

Differentiate between DROP TABLE, DROP clause of ALTER TABLE.

Answer
DROP TABLEDROP clause of ALTER TABLE
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 remove a specific component of a table, such as columns, constraints, or indexes.
The syntax is : DROP TABLE table_name;The syntax is : ALTER TABLE table_name DROP COLUMN column_name;