Which statement removes all rows from the "orders" table without removing the table structure?
TRUNCATE or TRUNCATE TABLE command is used to delete rows from the specified table without affecting the table itself.
  • 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

The right choice needs correction. It must be "TRUNCATE TABLE orders".

2020 Oct 5, 9:35:30 AM

Следи за CodeGalaxy

Мобильное приложение Beta

Get it on Google Play
Обратная Связь
Продолжайте изучать
тесты по SQL
Зарегистрируйся сейчас
или Подпишись на будущие тесты