Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37648 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
How can you append an identity column to a temporary table?
How would we use distinct statement? What is its use?
Can we call stored procedure in view in sql server?
Does the unique constraint create an index?
If user is owning any SQL Objects, can we drop that user
What is a cube? : sql server analysis services, ssas
What are the main sources of data?
What are the types of subquery?
Do you know what is xpath?
Is BCNF better than 2NF & 3NF? Why?
How many categories of functions based their return modes?
Can an entity have two primary keys?
Explain what are sparse columns?
Explain indexed views and partitioned view with their syntax.
what stored procedure would you use to view lock information? : Sql server administration
