In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETETRUNCATEDROPREMOVE

Break Down the Problem

1. Identify the purpose of the SQL command: removing data while keeping the table structure intact.
2. Analyze the provided options to determine their specific functions.

Relevant Concepts

• DELETE: This command removes rows from a table based on a condition. If no condition is specified, all rows are removed, but the structure remains intact.
• TRUNCATE: This command removes all rows from a table but retains the table’s structure and resets any auto-increment values.
• DROP: This command deletes the entire table including its structure and data.
• REMOVE: This is not a standard SQL command for table operations.

Analysis and Detail

• DELETING a table's data without affecting its structure can be achieved using either DELETE or TRUNCATE. However, TRUNCATE is specifically designed for removing all rows quickly and efficiently without logging individual row deletions.

Verify and Summarize

• Using DELETE can maintain table structure but may be slower if the table is large since it logs individual row deletions.
• TRUNCATE is more efficient for removing all data without needing to detail each row.

Final Answer

The command used to remove a table's data but keep the structure is TRUNCATE.