Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25172 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 do you mean by data manipulation language?
What is the significance of null value and why should we avoid permitting null values?
Differentiate between a primary key and a unique key.
How to write a query with an inner join in ms sql server?
In what three ways is the return statement used in a stored procedure?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is a not null constraint?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How to assign null values to variables or columns?
How to modify an existing stored procedure in ms sql server?
Mention the different authentication modes in sql server.
How to connect a database with sql express.?
Why use update_statistics command in sql server?
What is a field in a table?
Define msdb database?
