Nadrek (3/21/2013)

---

I also had to think about DML vs. DDL, because TRUNCATE is more or less equivalent to:

DELETE FROM + Reset Identity

and

DROP TABLE(etc.) + CREATE TABLE(etc.)

For me, the clincher was the ALTER TABLE permissions requirements of TRUNCATE - which I personally absolutely disagree with. I'd much rather see users able to use TRUNCATE based on perhaps

DELETE permission plus a new RESET IDENTITY permission, which being prohibited from creating tables, dropping tables, adding columns, redefining columns, etc.