Truncate Table

Question

Truncate Table

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply

jfgoude SSCrazy Points: 2586 More actions · Answer 1

not really a frequent usage, but an interesting question

B's-Data SSChasing Mays Points: 607 More actions · Answer 2

Good question but neither answer was correct. Granted you do NOT get an error but the truncate does not technically run either. If you go back and view the table data you will see that data has not been removed.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

bgdjwoods (4/30/2013)
Good question but neither answer was correct. Granted you do NOT get an error but the truncate does not technically run either. If you go back and view the table data you will see that data has not been removed.

Don't know what you are doing, but I added a couple of selects and it sure looks like the data is gone to me:

CREATE TABLE dbo.Test

(

Col_1 INT PRIMARY KEY

,Col_2 INT REFERENCES Test(Col_1)

,Col_3 INT IDENTITY

)

;

INSERT INTO dbo.Test VALUES (1,1);

INSERT INTO dbo.Test VALUES (2,2);

INSERT INTO dbo.Test VALUES (3,3);

GO

select * from dbo.Test;

go

TRUNCATE TABLE Test;

GO

select * from dbo.Test;

go

drop table dbo.Test;

go

Arno Kwetters Hall of Fame Points: 3704 More actions · Answer 4

Yeah, you were right about the foreign key and deletion.