What is the difference between truncate and delete statement?
Answer Posted / sreejith s t
Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain what role entity and relationship play in an ER diagram.
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to create an multi-statement table-valued function?
Can a table be created inside a trigger?
What are the five characteristics of good data?
What is the purpose of grouping data in a report?
What options are available to audit login activity? : sql server security
where the connection string store in the database
Why do we use functions?
What is tempdb database? : SQL Server Architecture
Is the primary key column of a table an index in ms sql server?
How to set database to be single_user in ms sql server?
What are the different types of sub-queries?
How to use old values to define new values in update statements in ms sql server?
How to generate create view script on an existing view?