Multiple choice technology databases

Which of the following Sql statements is correct?

  1. TRUNCATE * from TABLE Sales

  2. TRUNCATE TABLE Sales

  3. TRUNCATE Sales TABLE

  4. TRUNCATE * FROM Sales
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The TRUNCATE TABLE statement is the standard SQL command used to delete all rows from a table efficiently. Syntax variations containing asterisks or placing the table keyword after the table name are incorrect syntax errors in standard database systems, making the other options wrong.

Keep practicing — related questions