Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23000 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
How to set a database state to offline in ms sql server?
what is a deadlock? : Sql server database administration
What do you mean by cardinality?
What is a trigger what are the advantages of trigger?
What is extent? Types of extents?
How to add additional conditions in SQL?
What is store procedure? When do you use?
What are sql servers used for?
What is temporal data type?
What is meant by Active-Passive and Active-Active clustering setup?
List some of the rules that apply to creating and using a ‘view’
What are three major types of constraints?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Can we call stored procedure in trigger?
What is the federation in sql azure?
