Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 20445 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul goel
There are many differences. Some of these are as follows:
1. Delete can be rollback but Turncate can not be rollback.
2. Delete is a DML command and Turncate is a DDL command.
3. Delete command is used for deleting one or more row from
the table whereas Turncate command is used for deleting all
rows from the table.
4. Turncate is fact as compared to delete command.
5. we can use where clause with Delete but where is not
possible with Turncate.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Will count(column) include columns with null values in its count?
What is sql server replication? : sql server replication
Can a rule be bound to any column of any data type?
How to bind a view to the schema of the underlying tables?
what protocol both networks use? : Sql server database administration
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Can you explain full-text query in sql server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Can we call future method from queueable?
What is a result set object returned by odbc_exec()?
What is a synonym for manipulation?
How do I determine how many instances of sql server are installed on a computer?
what is the main function of a query parameter?
How much memory that we are using in Logshipping Concept?
What stored by the master?
