Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22588 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
What does set rowcount do?
Which data type columns are the best candidates for full-text indexing?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What happens if ntwdblib.dll is missing on your machine?
How do I find my localdb version?
Mention the differences between local and global temporary tables.
What is clr ddl trigger?
write an SQL query to list the employees who joined in the month of January?
Can binary strings be used in arithmetical operations?
What is filtered index?
Is null vs coalesce?
What are the basic functions for master, msdb, model, tempdb databases?
explain how to create a new schema in a database? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Explain logical operators in sql server?
