Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37001 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
What is the difference between dbcc indexdefrag and dbcc reindex?
What are the commands used in DCL?
Determine when an index is appropriate?
What are sql server functions?
What is report subscription?
What are locks in sql?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is 2nf normalization form?
What is change tracking in sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
how you can deploy an ssrs report?
When is update_statistics command used?
define and explain the differences between clustered and non-clustered indexes.
What is plan freezing?
Please explain what is “asynchronous” communication in sql server service broker?
