Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37600 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 does indexation mean?
What are Spatial data types in SQL Server 2008
What is a functions and types in sql server?
What is difference statement and preparedstatement?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Explain stored procedure?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Differentiate between a having clause and a where clause.
How do I port a number to sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Which rendering formats are affected by the pagesize properties?
How to use go command in "sqlcmd"?
What is acid db?
What is optimistic concurrency?
