Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 20450 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay dev arya
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 ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to create a new table in a given schema?
Can group by be used without aggregate functions?
How can I get data from a database on another server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What does REVERT do in SQL Server 2005?
What is cube dimension? : sql server analysis services, ssas
How much memory that we are using in Logshipping Concept?
What is dynamic cursor in SQL SERVER?
What does select 1 mean?
Write the syntax for stuff function in an sql server?
which backup strategy you are following at ur company
What will happen if a column containing char type data is changed to the nchar data type?
What is mean by dml?
How and why use sql server?
What is sql server programming?
