What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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
What is TDS(Tabular Data Stream) Gateway?
What are group functions in query statements in ms sql server?
What is a synonym for manipulation?
How do I find the query plan in sql server?
How do you make a trace?
Where are stored procedures in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is subquery in sql?
What is encryption key?
What is the command used to check locks in microsoft sql server?
Explain indexed views and partitioned view with their syntax.
Explain what is scheduled job and how to create it?
Explain syntax for viewing, dropping and disabling triggers?
How do I get to sql server configuration manager?
How to create stored procedures with parameters in ms sql server?