Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 20465 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 39 Yes | 6 No |
Post New Answer View All Answers
What are sub reports and how to create them?
Why we need sql server?
Why variables called the most powerful component of ssis?
List the different normalization forms?
What do you need to connect php to sql server?
What is the current limitation of the size of SQL Azure DB?
What is database white box testing?
what is hash nonclustered index
How to convert a unicode strings to non-unicode strings?
Explain having clause?
How to resolve the orphan use problem? : sql server security
What is recompile sql server?
What are the difference between primary key and unique key? : sql server database administration
How to disable stored procedure sql server?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
