Can you tell me the difference between DELETE & TRUNCATE
commands?

Answer Posted / vijay dev arya

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 ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of database schema? : sql server analysis services, ssas

814


Why use sub query in sql server and list out types of sub queries?

750


What is delete query?

732


Define left outer join?

779


What is partition in sql server?

745


What does the on delete cascade option do?

776


What are different types of subquery?

941


How to drop an existing schema in ms sql server?

788


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

774


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

747


What the different topologies in which replication can be configured?

756


What is the stuff and how does it differ from the replace function?

755


List the different normalization forms?

738


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

124


How to create a stored procedure with a statement block in ms sql server?

791