What is the difference between Drop and Truncate
- 20 Answers
- 33976 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / koti-khammam
TRUNCATE: Only data is deleted structure of the table
exists.
DROP: Both data and structure of the table gets removed.
| Is This Answer Correct ? | 57 Yes | 1 No |
Post New Answer View All Answers
When is the use of update_statistics command?
Why it is recommended to avoid referencing a floating point column in the where clause?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What are the steps to process a single select statement?
Can two different columns be merged into single column? Show practically?
What are the types of indexes?
Is foreign key unique?
What is sql stored procedure?
What is cached report?
Comment,Datatypes are unlimited
What is the difference between a unique key and primary key?
What is the difference between getdate and sysdatetime?
What is the use of toad or sqldbx.?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
