Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Dec 2005
    Location
    agra
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    delete and truncate

    sir

    what is the difference b/w delete table and truncate table ?

  • #2
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    TRUNCATE Drops and recreates a table, is faster than a delete and means that sequences are reset.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •