Truncate Table

Question

Post reply

Truncate Table

rcaro

SSC Enthusiast

Points: 102
More actions
June 21, 2015 at 2:21 am

#319185

Comments posted to this topic are about the item Truncate Table
June 22, 2015 at 3:32 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

EZ

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Arno Kwetters Hall of Fame Points: 3727 More actions · Answer 2

It looked to easy that TRUNCATE would work at the DELETE permission.

TRUNCATE looks like delete but it is indeed an ALTER command.

A little fly in the ointment

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

Umer Akram

SSC-Insane

Points: 22209

June 22, 2015 at 1:58 am

#1806942

nice question, Thanks for sharing

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

Arno Kwetters

Hall of Fame

Points: 3727

June 22, 2015 at 3:41 am

#1806973

I couldn't say it better Steward !

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

ArnoKwetters (6/22/2015)
It looked to easy that TRUNCATE would work at the DELETE permission.
TRUNCATE looks like delete but it is indeed an ALTER command.
A little fly in the ointment

Furthermore, Delete: DML, Truncate: DDL, have a nice day.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant