Multiple choice

Select the SQL statement which is used to delete the data inside a table.

  1. SQL DELETE

  2. SQL DROP TABLE

  3. SQL DROP INDEX

  4. SQL DROP DATABASE

  5. SQL TRUNCATE TABLE
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The SQL TRUNCATE TABLE statement is used to delete only the data inside a table and not the table itself.

Keep practicing — related questions