Microsoft SQL Server Getting started with Microsoft SQL Server DELETE All Rows
Example
DELETE
FROM Helloworlds
This will delete all the data from the table. The table will contain no rows after you run this code. Unlike DROP TABLE, this preserves the table itself and its structure and you can continue to insert new rows into that table.
Another way to delete all rows in table is truncate it, as follow:
TRUNCATE TABLE HelloWords
Difference with DELETE operation are several:
- Truncate operation doesn't store in transaction log file
- If exists
IDENTITYfield, this will be reset - TRUNCATE can be applied on whole table and no on part of it (instead with
DELETEcommand you can associate aWHEREclause)
Restrictions Of TRUNCATE
- Cannot TRUNCATE a table if there is a
FOREIGN KEYreference - If the table is participated in an
INDEXED VIEW - If the table is published by using
TRANSACTIONAL REPLICATIONorMERGE REPLICATION - It will not fire any TRIGGER defined in the table
