Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38371 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / pavan
Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.
| Is This Answer Correct ? | 72 Yes | 3 No |
Post New Answer View All Answers
What do I need to start working with sql studio? : sql server management studio
How to concatenate two binary strings together?
what is denormalization and when would you go for it? : Sql server database administration
What do you mean by an execution plan? Why is it used? How would you view it?
Does group by sort data?
What is difference between count (*) and count 1?
Explain indexed views and partitioned view with their syntax.
what is a transaction and what are acid properties? : Sql server database administration
How to make a column nullable?
How do you open a cluster administrator?
What are the dis_advantages of stored procedures, triggers, indexes?
How do I get to sql server configuration manager?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are different types of raid configurations? : SQL Server Architecture
