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
What are the types of database schema? : sql server analysis services, ssas
Why use sub query in sql server and list out types of sub queries?
What is delete query?
Define left outer join?
What is partition in sql server?
What does the on delete cascade option do?
What are different types of subquery?
How to drop an existing schema in ms sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What the different topologies in which replication can be configured?
What is the stuff and how does it differ from the replace function?
List the different normalization forms?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How to create a stored procedure with a statement block in ms sql server?