Which of the following SQL command will delete the structure as well as…
2022
Which of the following SQL command will delete the structure as well as content of a table EMPLOYEE?
- A.
ERASE EMPLOYEE;
- B.
DELETE FROM EMPLOYEE;
- C.
DROP EMPLOYEE;
- D.
DROP TABLE EMPLOYEE;
Attempted by 2227 students.
Show answer & explanation
Correct answer: D
The SQL command DROP TABLE removes the entire table, including its structure, data, indexes, and constraints. DELETE FROM removes only the records, not the table structure.
A video solution is available for this question — log in and enroll to watch it.