Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37029 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / agnel
* A truncate removes all rows from a tablethat operation
cant be rolled back.
* A drop command removes a table from a database all the
tables rows indexes and privilleges will also be removed.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain optimistic and pessimistic concurrency?
Is truncate a dml command?
what are the types of indexes? : Sql server database administration
What is an example of a foreign key?
What is etl - extraction, transformation, and loading?
What are the different types of lock modes in sql server 2000?
Explain acid?
What is resultset concur_updatable?
How to use subqueries in the from clause in ms sql server?
Explain can you implement data mining in ssrs?
How do I run a trace in sql server?
What is local temp table?
What is updatable resultset?
What is clr ddl trigger?
What extended events?
