SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes) A. DROP TABLE table_name; B. DELETE TABLE table_name; C. DELETE FROM table_name; D. NONE Answer Workspace Report Discuss Answer with explanation Answer: Option C Explanation DELETE FROM table_name; will be used to delete all rows in a table and not the table itself. To delete the table itself, DROP command is used. Workspace
Discuss about the question