Home Forums Article Discussions Article Discussions by Author Discuss content posted by Naseer Ahmad Delete v Truncate RE: Delete v Truncate

  • March 20, 2013 at 11:19 pm

    #1599227

    Dineshbabu (3/20/2013)

    Thanks for recalling the basics.

    Still I have question, why it has been called as DDL command?

    I think due to different behavior of truncate command, it's consider as DDL Command.

    check the below link for more information

    http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx

    But anyway, good question and recall basic again. Good start of day. 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!