Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / pankaj kumar upadhyay
1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.
2)delete can roll back but truncate is not rollback.
3)Truncate is faster compare delete command.
4)delete is DML command while Truncate is DDL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are recommended options to be used while using db mirroring? : sql server database administration
What are truncate options available in sql server? : sql server database administration
Can we shrink data file in sql server?
Is candidate a key?
What is optimization and its types?
What is normalization? What number of normalization shapes are there?
What methods do you follow to protect from sql injection attack?
Do you know what is sql service broker?
What is relationship? What number of sorts of relationship are there?
What is the difference between a function and a trigger?
What are the basic features of a trigger in ms sql server?
What is the full form of ddl?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Can sql servers link to other servers like oracle?
What are Spatial data types in SQL Server 2008