Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19345 Views
- I also Faced
- E-Mail Answers
Answer Posted / nageswarao
1.truncate is DDL cmd.where as delete is a DML cmd.
2.truncate is similar to delete command without no
condition.
3.when u use truncate it restructure the table,wthout
bothering of data it deletes entire records.
but,delete is a logged transaction.before delete
records it copies to transaction log.then removes.
4.truncate take less time than delete in execution.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How can you list all the table constraints in a database?
Why main is user defined function?
What is hot add cpu in sql server 2008?
What is the syntax to execute the sys.dm_db_missing_index_details?
How you can add messages to the nt event log from within a stored procedure?
Do you know what are the properties of the relational tables?
what are different types of raid configurations? : Sql server database administration
What is the use of @@spid?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
what kind of lan types do you know? : Sql server database administration
How to use order by with union operators in ms sql server?
How do I view a stored procedure in sql server?
Explain insert into select statement?
Tell me what is de-normalization and what are some of the examples of it?
What are database states in ms sql server?
