Which statement removes all rows from the "orders" table without removing the table structure?
Explanation
Get an explanation when it's available:
Theory
  • The TRUNCATE TABLE Statement

    What if we only want to delete the data inside the table, and not the table itself?
    Then, use the TRUNCATE TABLE statement:
    TRUNCATE TABLE table_name
    Read more: SQL DROP

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL quizzes
Cosmo
Sign Up Now
or Subscribe for future quizzes