Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / guest
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
Is This Answer Correct ? | 39 Yes | 6 No |
Post New Answer View All Answers
Mention the differences between having and where clause.
Do you know what is sql injection?
What functions can a view be used to performed?
What is global temp table?
How to set database to be single_user in ms sql server?
What is the use of custom fields in report?
Tell me about normalization in DBMS.
Why should you use or avoid select * statements?
How to turn off warning messages during php execution?
What is a field in a table?
What is tcl in sql server?
What extended events?
When I delete any data from a table, does the sql server reduce the size of that table?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Does partitioning improve performance?