What is the difference between truncate and delete statement?
Answers were Sorted based on User's Feedback
Answer / valarmathi
truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.
delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rajiv singh
Truncate deletes all rows from table. But Delete deletes
row/rows by condition.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / ismail hasan
truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.
Delete statement will delete a particular row(s) on your
choice.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vasu
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 ? | 1 Yes | 0 No |
Answer / balaji t
Identity counter can be reset in truncate whereas it is not possible in delete.Truncate dont activate trigger whereas delete can be used in triggers.truncate is a DDL command whereas delete is a DML command.
Is This Answer Correct ? | 0 Yes | 0 No |
What is dbcc?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are temporal tables in sql server 2016?
Selet all the data from table where last name is n of employee
How to delete database objects with "drop" statements in ms sql server?
what is the purpose of creating view is sql server 2000
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is a function? Give some example?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How to return the date part only from a sql server datetime datatype?
How to use subqueries with the in operators in ms sql server?
write the query for find the top 2 highest salary in sql server
36 Answers Cranes, Jayanti Software, Medi Assist, Rmax, TCS,