What is the difference between Drop and Truncate
- 20 Answers
- 34387 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
How to defragment indexes with alter index ... Reorganize?
How do you rebuild an identity column?
List the different index configurations possible for a table?
How to add a new dsn with the odbc driver for sql server?
What should be the fill factor for indexes created on tables? : sql server database administration
Explain use of expression builder.
What are different types of statement?
What is plan freezing?
Explain log shipping and mention its advantages.
How to apply filtering criteria at group level with the having clause in ms sql server?
What are the different index configurations a table can have?
How to select some specific rows from a table in ms sql server?
Write a SQL query in order to merge two different columns into single column?
What do you mean by normalisation?
What is resource governor in sql server?
