Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22074 Views
- I also Faced
- E-Mail Answers
Answer Posted / sachin patil
Truncate is DDL Command while Delete is DML Command
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
Which are the third-party tools used in sql server and why would you use them?
What is extended stored procedures?
Explain transaction server auto commit?
What is replace and stuff function in sql server?
What are indexers?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Tell me what is the significance of null value and why should we avoid permitting null values?
Why transaction is important?
What are the types of table?
between cast and convert which function would you prefer and why?
What are the different index configurations a table can have?
What is the temp table?
What is use of dbcc commands?
Explain what is the difference between a local and a global temporary table?
Why Master database is required?
