• "It" refers to Truncate .

    It's a DDL , Data definition language - why ? I think because It resets the identity, that is a database object property change. [because, it does delete so should qualify for DML too ..]

    And It doesn't fire trigger , because deletion is actually page deallocations in case of truncate , not individual row deletions .

    thanks for the question

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm: