What is the difference between DELETE and TRUNCATE?
Answer Posted / raam
Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.
ramumcato@yahoo.com
| Is This Answer Correct ? | 9 Yes | 11 No |
Post New Answer View All Answers
How do I view tables in sql developer?
Is join and inner join the same?
How many types of triggers exist in pl/sql?
What is bulk collect in pl sql?
Difference between global and parameter variables?
How to add new employee details in an employee_details table with the following details
What is column?
What is execution plan in sql?
what is an extent ? : Sql dba
How do you write a complex sql query?
What is the maximum rows in csv?
Which one is faster ienumerable or iqueryable?
give the syntax of grant and revoke commands? : Sql dba
How do I truncate a word?
Where not exists in sql?