Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37844 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / arjun tailor
drop command will delete the entire row also the structure
but truncate will delete the contents only not the
structure.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between mysql and sql server?
Explain different types of self contained sub query?
Do you know sql server 2008 introduces automatic auditing?
How to reaname table name without using sp_Rename in sql server..?
How to Update from select query in sql server?
How can you stop stored procedures from recompiling?
What is named calculation? : sql server analysis services, ssas
Do I need a report server to run reports in my application?
What is standby servers? Explain types of standby servers.
Write the SQL query to drop, truncate and delete table.
What is database mirroring?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
how to define testing of network layers? : Sql server database administration
What new changes are being made in SQL Server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
