Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22669 Views
- I also Faced
- E-Mail Answers
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
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is the difference between functions and scalar functions?
Explain DBCC?
What is the usage of sign function?
What is the default value of an integer data type in sql server 2005?
Determine when an index is appropriate?
What is difference between after and before?
What are the components of dbms?
Explain an automatic checkpoint
Explain about extended stored procedure?
What is a field name?
Explain important index characteristics?
What is attribute relationships, why we need it? : sql server analysis services, ssas
what types of replication are supported in sql server? : Sql server database administration
