What is the difference between Drop and Truncate
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 RMS migrations?
What is the difference between functions and stored procedures?
What are indexers?
What is an execution plan?
What is a cache in ssrs?
What is clustered primary key?
How to create user messages with print statements in ms sql server?
What is a subquery in a select query statement in ms sql server?
Can you create a logon trigger in sql server 2005 express edition?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
List out the differences between global and local temp tables in sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is not null constraint?
Do I need a report server to run reports in my application?
What are the parts of a function?