sknox (3/21/2013)
Mechanically, TRUNCATE TABLE is DDL: It doesn't act on the row data, but on the metadata (this is why you need ddladmin rights.)
But functionally it's DML: its function is to delete data -- except when you get to the identity thing: that's DDL again.
So really, it's both: it's a DDL mechanism with a DML purpose.
I agree with you...
I have gone through this DDL vs DML command for TRUNCATE long time back... I went with the BOL/popular answer (dependent on the population I guess)
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe: