Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 21259 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
What is difference between materialized view and view?
Explain about SQLOS?
Does group by or order by come first?
How each E-R model constructs can be mapped to the relational model?
What is a DBMS, query, SQL?
What is wide table?
Can a database be shrunk with users active?
How many replicas are maintained for each SQL Azure database?
What is the use of toad or sqldbx.?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Explain the microsoft sql server delete command? : SQL Server Architecture
How can we delete Duplicate row in table?
Difference between Inner vs outer joins?
What language is sql server written in?
What is normalization of database? What are its benefits?
