Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15704 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / papia
Truncate table removes all rows from the table and alos
releases the storage space and as it is a DDL statement so
no Rollback information is available
Delete statement also removes the row but does not release
the storage space
Truncate is faster than delete.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Where can I learn sql for free?
Why do we use procedures in sql?
What are the topics in pl sql?
What is union?
Which operator is used in query for pattern matching?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Which table is left in join?
Why do we create stored procedures & functions in pl/sql and how are they different?
How to avoid duplicate records in a query?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
what does it mean to have quoted_identifier on? : Sql dba
how do you control the max size of a heap table? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
Is left join same as join?
What is the purpose of primary key?
