What is the difference between Drop and Truncate
- 20 Answers
- 33985 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Drop can be used to drop the entire table including data
and structure of table where as truncate removes rows from
table but the structure of table remains as it is.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What is de-normalization in sql database administration? Give examples?
Can you import Microsoft Excel data to SSRS?
How to add the custom code in Report?
What is resource governor?
What are built in functions?
Explain data warehousing in sql server?
What is a fan-out query in SQL Azure?
Explain sql server service broker?
What is difference statement and preparedstatement?
How can you list all the columns in a database?
What is the difference between resultset and resultsetmetadata?
Can I use sql azure as a backup with log shipping or database mirroring?
What is key set driven?
How many replicas are maintained for each SQL Azure database?
How to insert and update data into a table with "insert" and "update" statements?
