Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19340 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 define testing of network layers? : Sql server database administration
What are the system database in sql server 2005?
Explain raiserror in sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
How to change server name in sql server?
What are distinctive joins find as a part of sql?
Explain external key management in sql server 2008
What is the difference between a "where" clause and a "having" clause?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Does partitioning help performance?
What is purpose of normalization?
How to create a user name in a database?
In what sequence sql statement is processed?
How can I change procedure name in sql server?
How to change the data type of an existing column with "alter table" statements in ms sql server?
