Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18991 Views
- I also Faced
- E-Mail Answers
Answer Posted / srisenthil
delete table gives the transactional log where as in
truncate it is not delete the total rows inthe table but
structure of the table has never changed after the
statement is executed it is roll back and the constraints
after the delete statement is remain same where as it is
not in the truncate statement
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What are the steps you can take to avoid “deadlocks”?
How to transfer an existing table from one schema to another schema in ms sql server?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Why is the need for data conversion transformations?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Which are new data types introduced in sql server 2008?
How many levels of sp nesting is possible?
What is 2nf normalization?
What are the restrictions that views have to follow?
How to add an address record into adventureworkslt?
What are the system database in sql server 2008?
How to display a past time in days, hours and minutes?
Tell me what is the order in which the sql query is executed?
How to query multiple tables jointly?
Why use “pivot” in sql server?
