What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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
Tell me what is difference between clustered and non clustered index?
Tell me what is log shipping?
What is a non-clustered index?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is the cartesian product of the table?
What is data mart? : sql server analysis services, ssas
Explain primary key, foreign key and unique key?
What are audit control procedures?
List out different types of normalizations in sql server and explain each of them?
How do I view a script in sql server?
What is the purpose of linked server configuration in sql server?
In what three ways is the return statement used in a stored procedure?
Can you explain what is indexed view? How to create it?
What are the advantages of using stored procedures?
What happens if null values are involved in comparison operations?