What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20359 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
List some case manipulation functions in sql?
How do I delete a sql server database?
How to use transact-sql statements to access the database engine?
What is the datatype of rowid?
Why do you want to join software field as you have done your BE in Electronics?
What is factless fact table? : sql server analysis services, ssas
How do you debug a procedure in sql server?
What structure can you implement for the database to speed up table reads?
Explain Reporting Life Cycle?
what's the information that can be stored inside a bit column? : Sql server database administration
What are the advantages of user-defined functions over stored procedures in sql server?
What is difference between join and natural join?
What is a functions and types in sql server?
Explain the concepts and capabilities of sql server?
Explain indexing and what are the advantages of it?
