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


Please Help Members By Posting Answers For Below Questions

Mention the differences between having and where clause.

812


Do you know what is sql injection?

748


What functions can a view be used to performed?

823


What is global temp table?

763


How to set database to be single_user in ms sql server?

811


What is the use of custom fields in report?

783


Tell me about normalization in DBMS.

777


Why should you use or avoid select * statements?

758


How to turn off warning messages during php execution?

776


What is a field in a table?

802


What is tcl in sql server?

873


What extended events?

794


When I delete any data from a table, does the sql server reduce the size of that table?

789


Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

802


Does partitioning improve performance?

744