Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38389 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
How can we determine what objects a user-defined function depends upon?
How to delete an existing database user?
how many type of indexing in database?
Explain various data region available in ssrs with their use?
What are the different types of sub-queries?
Why is replication required on the sql server?
What is rs.exe utility?
What is model database? : SQL Server Architecture
How to create percentile function?
When do you think a developer should use sql server-based cursors?
How do you troubleshoot errors in a SQL Server Agent Job?
What is sql server schema compare? How we can compare two database schemas?
What are the properties of the transactions?
Can we write a distributed query and get some data which is located on other server and oracle database?
Can coalesce return null?
