SQL 2023 · Changing data
Empty a table quickly
Remove all rows from a table at once.
TRUNCATE TABLE logs;
Caution: Deletes all rows immediately and can't be filtered. In some databases it can't be rolled back.
Official SQL 2023 documentation
SQL 2023 · Changing data
Remove all rows from a table at once.
TRUNCATE TABLE logs;
Caution: Deletes all rows immediately and can't be filtered. In some databases it can't be rolled back.
Official SQL 2023 documentation
Was this page helpful?