Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37821 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Drop can be used to drop the entire table including data
and structure of table where as truncate removes rows from
table but the structure of table remains as it is.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What the different types of Replication and why are they used?
How to make a remote connection in a database?
What is a group function explain with an example?
Is t sql the same as sql server?
How to find index size for each index on table?
What is the difference between lock, block and deadlock? : sql server database administration
What is triggers and stored procedures?
What is the use of builtinadministrators group in sql server? : sql server security
What is resultset concur_updatable?
What are page splits?
How to connect to a sql server using odbc_connect()?
We need to perform what steps in the following order to work with a cursor?
What is cursor in ms sql server?
What is a transaction and why is it important?
What are the differences between lost updates and uncommitted dependencies?
