1. #1
    Sencha User
    Join Date
    Jun 2016
    Posts
    1
    Vote Rating
    0
    sonal10 is on a distinguished road

      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
    yadavveronica is on a distinguished road

      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

Thread Participants: 1

Tags for this Thread