what is the difference between Delete and Truncate
- 4 Answers
- 7638 Views
- CarrizalSoft Technologies, Geo Research Centre, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
Delete command execute row by row and it can't reset any
identity column's value.
But using Truncate command it reset all table and Identity
column also.So truncate command is fast then delete command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the underflow and overflow behaviors on float literals?
Why use triggers?
What is difference between foreign key and unique key?
Explain user defined views?
What are the different index configurations a table can have?
How to verify a login name with sqlcmd tool?
Explain what is public role in sql server?
Tell me what is the order in which the sql query is executed?
How to provide column names in insert statements in ms sql server?
Explain what is the function of sql server agent windows service?
How to get the number of affected rows?
Explain unique key in sql server?
List out a number of the wants to setup a SQL Server failover cluster?
Explain left outer join and right outer join?
How to create user messages with print statements in ms sql server?
