Question

which can be used to delete all the rows if a table​

Answer 1

Answer:

The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.

Answer 2

The TRUNCATE  command is used to delete all the rows in a table.

Detailed answer

The truncate command is used in SQL to delete all the rows that are present in a column.

• This also helps to free the space that the table was occupying earlier before the command is executed.
• The complete data of a table is deleted together.
• This is done by deallocating the pages that are found between them this is one of the most commonly used commands.