Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22586 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 a sub-report?
How can you stop stored procedures from recompiling?
Is it possible to update the views? If yes, how, if not, why?
What is table constraint?
How to use old values to define new values in update statements in ms sql server?
What is the difference between char and varchar2 datatype in sql?
What is the difference between rank and dense_rank?
Explain indexed views?
How to reaname table name without using sp_Rename in sql server..?
What is dirty read?
What stored by the msdb? : sql server database administration
Can I work with several databases simultaneously? : sql server management studio
What is exporting and importing utility?
Does transparent data encryption provide encryption when transmitting data across the network?
What is a trace frag? Where do we use it?
