Question

The command to eliminate a table from a database is
A) REMOVE TABLE CUSTOMER;
B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER;
D) DROP TABLE CUSTOMER;

Answer 1

hey there!!!



Answer:- D)is correct option

Answer 2

"DROP TABLE CUSTOMER used to eliminate table from database".

Explanation :

In SQL, the DROP  statement is used to remove all the Structure from the table definition and all the data, indexes, triggers, constraints, and approval specifications for that particular table.

Option A: For removing the data, we use the DELETE statement in SQL but the REMOVE statement is not applicable.

Option B: The UPDATE statement in SQL is used to update the content and data of the table.

Option C: In SQL, a DELETE statement is used to delete the existing data and records in a table.