Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37024 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh
Drop: Table structure + Data are deleted
Truncate: Data alone deleted but it is faster than delete.
Here we can not use where Condition here.
Delete: Data alone deleted. Here we can use where condition
here
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How many levels of sp nesting are possible?
How you trouble shoot when any job fails
What are the components of sql server service broker?
what are triggers? : Sql server database administration
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What sql server means?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Does hive support indexing?
What are the types of resultset?
What is the maximum size of column in sql server?
How to update muliple row in single query?
List the different types of joins?
Explain difference between cross join and full outer join?
How do I create a partition table in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
