Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25571 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
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is ddl command?
Explain about sql server login?
How to get a list of columns using the "sys.columns" view in ms sql server?
What are cursors and when they are useful?
How do I find information about the install locations for the various instances running on a computer?
What is database black box testing?
What is sql sandbox in sql server?
What is normalization? Explain different forms of normalization?
how to avoid cursors? : Sql server database administration
Explain nested trigger in sql?
How to test values returned by a subquery with the in operator?
What is a transactions?
How to create new databases with "create database" statements?
How is a full-text index updated?
