SQL Server 2017 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE MyTable (ID int not null, TextValue nvarchar(1000) not null);
INSERT INTO MyTable VALUES (1, 'One');
INSERT INTO MyTable VALUES (2, 'Two');
INSERT INTO MyTable VALUES (3, 'Three');
INSERT INTO MyTable VALUES (4, 'Four');
 
SELECT * FROM MyTable


ID
TextValue


1
One

2
Two

3
Three

4
Four


BEGIN TRAN
TRUNCATE TABLE MyTable
SELECT * FROM MyTable
ROLLBACK TRAN
SELECT * FROM MyTable


ID
TextValue




ID
TextValue


1
One

2
Two

3
Three

4
Four


BEGIN TRAN
delete MyTable where 1=1
SELECT * FROM MyTable
ROLLBACK TRAN
SELECT * FROM MyTable


ID
TextValue




ID
TextValue


1
One

2
Two

3
Three

4
Four