Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 54 of 79

Table Creation and Data Manipulation Commands — Question 9

Back to all questions
9
Question

Question 8(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;