Results 1 to 2 of 2

Thread: What is a key difference between Truncate and Delete?

  1. #1
    Sencha User
    Join Date
    Jun 2016
    Posts
    1
    Vote Rating
    0
      0  

    Default What is a key difference between Truncate and Delete?

    pls tell me about this things

    thanks in advance

  2. #2
    Sencha User
    Join Date
    Jun 2016
    Posts
    1
    Vote Rating
    0
      0  

    Default

    Truncate is used to delete table content and the action can not be rolled back, whereas Delete is used to delete one or more rows in the table and can be rolled back
    TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log whereas the DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row
    Truncate identify column is reset to its seed value if table contains any identity column.
    Delete statement identity of column keep DELETE retain the identity
    To use Truncate on a table you need at least ALTER permission on the table whereas to use Delete you need DELETE permission on the table.
    Truncate uses the less transaction space than Delete statement. Delete uses the more transaction space than Truncate statement.

    https://intellipaat.com/tutorial/sql-tutorial/

Similar Threads

  1. [SOLVED] Grid with One Column data truncate?
    By dbspaceg in forum Sencha Architect 2.x: Help & Discussions
    Replies: 3
    Last Post: 20 Feb 2012, 7:02 PM
  2. [MOVED] Please Implement Delete Key to delete items in addition to Delete Menu Item
    By markjlyon in forum Ext Designer: Help & Discussion
    Replies: 1
    Last Post: 11 May 2010, 7:48 AM
  3. Truncate panel title
    By LisburnLad in forum Ext 2.x: Help & Discussion
    Replies: 3
    Last Post: 27 Mar 2009, 2:28 PM
  4. Truncate row's text inside a grid
    By marco76 in forum Ext 2.x: Help & Discussion
    Replies: 1
    Last Post: 12 Jan 2009, 10:23 AM

Tags for this Thread

Posting Permissions

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