Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19113 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
How to change the name of a database user?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is the difference between char, varchar and nvarchar?
Do you know what is a trace frag? Where do we use it?
What are the new features of sql server 2008 r2 reporting service?
What is merge statement?
How to create function with parameter in sql server?
How to edit table in sql server 2017?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is the bookmark lookup and rid lookup?
How to convert numeric expression data types using the cast() function?
What is wide table?
How to insert data into an existing table?
what is a correlated sub-query? : Sql server database administration
What is report rendering ?
