What is the difference between Drop and Truncate
- 20 Answers
- 34142 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / pavan
Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.
| Is This Answer Correct ? | 72 Yes | 3 No |
Post New Answer View All Answers
What is the difference between varchar and nvarchar?
Explain something about security and SQL Azure?
what happens on checkpoint? : Sql server database administration
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How do you improve the performance of a SQL Azure Database?
What have included columns when we talk about sql server indexing?
How can you find out which stored procedures are recompiling?
What do you understand by SQL*Net?
How to delete all rows with truncate table statement in ms sql server?
What is tabulation?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Do you know the isolation level that sql server support?
How to view the error log for any specific instance? : sql server database administration
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to handle error or exception in sql?
