Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37878 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 is the difference between nvl and nvl2?
What is the purpose of self join?
When would you prefer to have a minimum number of indexes?
Explain what are the restrictions while creating batches in sql server?
Difference between 2NF &3NF ?
What is delete query?
Write query to return all rows sql?
Using the customer, and order table in northwind database, please write a query to produce xml?
Explain features and concepts of analysis services?
How to define output parameters in stored procedures?
What is report snapshot?
What is the data tier application?
How to use order by with union operators in ms sql server?
What is faster join or union?
Where is my database stored on the hard disk in ms sql server?
