Which of the following commands is used to delete all rows and free up space from a table?TRUNCATEDROPDELETEALTER

To determine which command is used to delete all rows and free up space from a table, we need to analyze the given options:

1. TRUNCATE: This command is used to remove all rows from a table but does not log individual row deletions. It does free up space immediately and resets any auto-increment counters.

2. DROP: This command removes the entire table from the database, including all rows, columns, and associated data. However, it's not used to delete rows from an existing table while keeping the structure intact.

3. DELETE: This command deletes rows from a table based on a condition specified in a WHERE clause. If no condition is provided, it removes all rows, but it does not free up the space immediately as it logs each row deletion.

4. ALTER: This command is used to modify an existing database object like a table, adding new columns or changing data types, not for deleting rows.

Final Answer

The command used to delete all rows and free up space from a table is TRUNCATE.