Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 20449 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohsin mohammed abdul
Delete command deletes the data from the tables .. but can
get back on issue of roll back whereas when you issue
truncate deletes the records and oracle implicitly issues
commit command and even when you issue rollback you won't
get the data back
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
1 01 101 01010
What is the difference between system objects and user objects?
What is blocking and how would you troubleshoot it? : sql server database administration
explain databases and sql server databases architecture? : Sql server database administration
When I run the sql server 2000 setup, it just hangs. What do I do?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What are data files?
What is self contained scalar sub query?
How do you rebuild an identity column?
Do you know hot add cpu in sql server 2008?
What is the difference between varchar and nvarchar datatypes?
What are the disadvantages of using querystrings to send data from one page to another?
What is create command?
Explain partitioned view?
What is t-sql script to take database offline – take database online.
