Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37609 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / swathi
drop will remove the entire table from the database and can
be rollbacked.
truncate will remove the content of the table and it cannot
be rollbacked.
truncate is little bit faster than drop.
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
What is local temp table?
What are different types of statement?
What is sql injection? How to protect against sql injection attack?
What are the advantages of the mirroring?
Explain datetime2 data type in sal server 2008?
What is a derived table?
What should be the fill factor for indexes created on tables? : sql server database administration
What do you know about normalization and de- normalization?
Explain in brief about Microsoft SQL server?
What is usually the first word in a sql query?
How to create a view with data from multiple tables?
Why use triggers?
How to generate random numbers with the rand() function in ms sql server?
Where is trigger in sql server?
What is lock escalation and what is its purpose?
