Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37822 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh
Drop: Table structure + Data are deleted
Truncate: Data alone deleted but it is faster than delete.
Here we can not use where Condition here.
Delete: Data alone deleted. Here we can use where condition
here
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the command used to check locks in microsoft sql server?
How exceptions can be handled in sql server programming?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to retrieve field values using mssql_result()?
What can be used instead of trigger?
How to download and install microsoft sql server management studio express?
how to use DTS package in 2000,2005,2008 in sql server
How do you check sql server is up and running?
Do you know how to send email from database?
How to handle error or exception in sql?
How to configure and test odbc dsn settings?
Explain primary key in sql server?
How to define and use table alias names in ms sql server?
How to connect php with different port numbers?
What is difference between line feed ( ) and carriage return ( )?
