Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38385 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / satyanarayana
Drop and Truncate commands both are DML commands.
If we use drop command it will deletes all the table data
as well as tablestructure.But if we use truncate command it
will deletes the table data only.
| Is This Answer Correct ? | 24 Yes | 44 No |
Post New Answer View All Answers
Can you please explain the difference between primary keys and foreign keys?
Explain external key management in sql server 2008
How do I partition a table in sql server?
What is cube dimension? : sql server analysis services, ssas
What do you understand by a stored procedure?
What are the dmvs?
What is an etl file?
what is a correlated sub-query? : Sql server database administration
What are the different types of sub-queries?
What is difference between drop truncate and delete?
How to achieve Paging of records in SQL SERVER?
Mention the differences between local and global temporary tables.
Does sql server 2000 clustering support load balancing?
What gets stored inside msdb database?
What is transaction server distributed transaction?
