what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / raja lakshmi reddy v
hi friends this is raja
Truncate:
1. Truncate is used to delete all rows at a time, so the
table will become as free. The user feel the table does not
contain any rows, eventhough but internally the data exist
some memory that memory is free for our reuse.
2. Truncate is faster than delete, and where clause never
possible.
3. It is ddl command so that it will not roll back because
auto commit by default.
4. in sqlserver autoid columns will reset since from
starting seed value.
Delete:
1. Delete is used to Delete particular rows or all with
where clause or without where clause.
2. remeber if u delete rows, eventhough that memory will
never free means separate memory will allocate to our table.
3. It is slower than the truncate.
4. in sqlserver autoid values will never start from seed
intial value or default value.
5. while deleting check constrains, if any problem errow
thrown.
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is an Oracle database Partial Backup?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
HOW TO SPOT AHIERARCHY?
key flexfield structure
can u give guidance abt packages of plsql
Why more redos are generated when the oracle database is in begin backup mode?
What is the use of lockboxes? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is the difference between oracle media recovery and crash recovery?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Can we modify approve purchase order?if yes what is navigation?
Explain prerequisites and post activities of oracle database installation