What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 18931 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nirmala.s
if u use delete to remove the data from the table,this will
delete the data.after using rollback the removed data can
be retrived.But in case of, truncate , it will delete the
data and that can't ever be retrived.even after using
rollback also. but the table structure of the table will
be there
if u are using drop command , this will delete entire
table.and its structure.
| Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
What is bulkcopy in sql?
What is a dataset and what are the different types of datasets?
Is natural join and equi join same?
What is oltp (online transaction processing)?
Explain about service Broker functions?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Define self join?
Please explain go command in sql server?
what are the different ways to return the rowcount of a table?
What is cursor in ms sql server?
How to loop through returning rows?
How to disable stored procedure sql server?
How to create an inline table-valued function?
Tell me something about security and sql azure?
