What is the difference between Drop and Truncate
- 20 Answers
- 32062 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vipin narwal
HI TO ALL!!!
DROP: will lead in deleting the structure of the table
along with all associated constraints like Primary
Key,Foreign Key,..etc and also deallocates the memory
allocated to the Database objects..
Truncate: Truncate like Delete deletes the data associated
with a Database Object but structure remains there i.e,
memory remains allocated,...but faster than Delete...
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can group by and orderby be used together?
Difference between Logical Page and Physical Page in SSRS.
Explain how dts is used to extract, transform and consolidate data?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
Explain identity in sql server?
How to make remote connection in database?
Why do we backup Active Directory ?
explain different types of constraints? : Sql server database administration
How many joins in sql server?
What is filtered index?
What do you know about normalization and de- normalization?
How do we Backup SQL Azure Data?
What is a ddl statement?
What are triggers? How do you invoke a trigger on demand?
How do you test your database? : sql server database administration
