Which SQL command removes both the table structure and its stored records?
Options
-
A.
DELETE
-
B.
TRUNCATE
-
C.
DROP TABLE
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
C.
DROP TABLE
Detailed Explanation
- DROP TABLE: Removes the table definition and its stored data.
- After dropping a table, its structure is no longer available.
- DELETE removes rows but retains the table structure.
OOps! You are currently offline.