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;
Answers
Answered by
8
hey there!!!
Answer:- D)is correct option
Answer:- D)is correct option
Answered by
0
"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.
Similar questions