Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?
A) DROP TABLE STUDENT;
B) DELETE TABLE STUDENT;
C) REMOVE TABLE STUDENT;
D) SELECT * FROM STUDENT THEN DROP;
E) DELETE FROM STUDENT;

Question

Quizplus · Accepted Answer

The DELETE FROM command with the table name will only remove the data from the table and leave the table structure intact. The other options such as DROP TABLE will completely remove the table along with its structure.

Which of the Following SQL Commands Would Be Used to Remove