Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24495 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
Why truncate is used in sql?
How do I remove duplicates in two columns?
Is sql a microsoft product?
What is the command used to fetch the first 5 characters of a string?
Can we have two clustered index on a table?
How many types of index are there?
How to load data with sql*loader?
What are the key differences between SQL and PL SQL?
Is sql port 1433 encrypted?
How to download oracle sql developer?
What are different types of queries in sql?
How do I count rows in sql query?
What are the ddl commands?
What is the purpose of using pl/sql?
How do I run a sql script?
