Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25584 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / babloo
when truncate command is issued, all the rows from the
table are deleted and the memory space occupied by the
table in the tablespace is also released whereas when
delete command is issued, only all the rows are deleted
fronm the table
| Is This Answer Correct ? | 28 Yes | 0 No |
Post New Answer View All Answers
How many disk partitions should I have?
How delete all records from table in sql?
What is right join in sql?
How do you declare a constant?
How many aggregate functions are available there in sql?
How can you fetch common records from two tables?
how to use 'mysql' to run sql statements? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
what is recursive stored procedure? : Sql dba
What is not in sql?
How do you optimize a stored procedure in sql?
What do you mean by query optimization?
Why stored procedure is better than query?
How is debugging done?
what are the type of locks ? : Sql dba
