• 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: