Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25589 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil
Delete Commands:
it is dml statement
you can specify delete command with critery (where
condition)
syntax: Delete * from tablename where condition
Truncate Command:
it is DDL statement
you can not specify critery with truncate table
syntax: truncate table tablename
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is normalization? What number of normalization shapes are there?
Why truncate is ddl command?
Which language is supported by sql server?
What is filter index?
Define synonym?
Why transaction is important?
Which language rdl files made of?
What is the purpose of the tempdb database?
What are examples of triggers?
How do indexes help, types?
Why do we need normalization?
What action plan is preferred if sql server is not responding?
What is the difference between varchar and varchar types?
What is public role in sql server?
Can you explain about buffer cash and log cache in sql server?
