What is the difference between truncate and delete statement?
Answer Posted / ismail hasan
truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.
Delete statement will delete a particular row(s) on your
choice.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is difference between aggregate and analytic function?
What is dimension table? : sql server analysis services, ssas
Can I use sql azure as a backup with log shipping or database mirroring?
Do you know what is rank function?
Which data type columns are the best candidates for full-text indexing?
explain declarative management framework (dmf) in sql server 2008?
What is function of master database?
What is relationship? What number of sorts of relationship are there?
How network traffic be reduced by using the stored procedure?
What are various aggregate functions that are available?
How to convert numeric values to integers in ms sql server?
What are the general features of sql server management studio? : sql server management studio
How do I view views in sql server?
How to delete an existing database user?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration