Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37030 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
How to disconnect from a sql server using mssql_close()?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the triggers in sql?
Does index slows down insert statements?
Where views are stored in sql server?
How to check if stored procedure is running in sql server?
What are the disadvantages of merge replication?
What are sub reports and how to create them?
Define Joins?
What happens when transaction log is full?
Explain what are the different index configurations a table can have?
How data can be copied from one table to another table?
How many databases Microsoft SQL server provides?
What options are available to audit login activity? : sql server security
How to write a query with a left outer join in ms sql server?
