Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 21256 Views
- I also Faced
- E-Mail Answers
Answer Posted / amita
Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.
| Is This Answer Correct ? | 3 Yes | 28 No |
Post New Answer View All Answers
Mention what are the core components of ssrs?
When should you use an instead of trigger?
What are types of scd? : sql server analysis services, ssas
How can you find out how many rows returned in a cursor?
Where to find ntwdblib.dll version 2000.80.194.0?
What does <> symbol mean?
What is left outer join in sql server joins?
How many null values we can have in a unique key field in sql server?
What is compound operators?
What is single-user mode?
Explain view in sql server?
Can you please explain the difference between primary keys and foreign keys?
Do you know what is rank function?
How to create new table with "create table" statements?
how to use DTS package in 2000,2005,2008 in sql server
