User Id :    Password :      New Member   Forgot Password  
Topic: Can you tell me the difference between DELETE and TRUNCATE commands
Sachin Jain
30 Oct 2010 at 02:06 AM
Can you tell me the difference between DELETE and TRUNCATE commands.

Re: Can you tell me the difference between DELETE and TRUNCATE commands
Gaurav
31 Oct 2010 at 11:34 PM
Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.
Total Replies: 1
 
Featured Text Ad

Featured Ad