Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37861 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 a transaction and why is it important?
Explain different types of locks in sql server.
What happens if null values are involved in datetime operations?
How check triggers in sql server?
Do you know concepts and capabilities of sql server?
What is subquery explain with example?
What is a fill factor?
How to configure and test odbc dsn settings?
Explain “row_number()” in sql server with an example?
Why is replication required on the sql server?
How to handle error or exception in sql?
Are connections to sql server encrypted?
How to drop an existing table?
What are the benefits and tasks of object explorer? : sql server management studio
What are the different types of replication are there in sql server 2000?
