What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
Answer Posted / sreedhar
Truncate is DDL command, Delete is a DML command.
Delete operation can be rolled back and in truncate we
can't.
Where caluse can be used in Delete and not in Truncate.
Truncate table less time than delete in execution
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Explain how to maintain a fill factor in existing indexes?
What the different components of Replication and what is their use?
tell me the disaster recovery plan
What is the most common type of join?
What is the recovery model? List the types of recovery model available in sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
explain the storage models of olap? : Sql server database administration
How to enter unicode character string literals in ms sql server?
How to check parameter value in stored procedure sql server?
Why normalization is used?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is candidate key with example?
What is normalization? Explain its different types?
What is clr ddl trigger?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?