Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15715 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
How do I add a primary key to a table?
What is sql resultset?
What is rollback?
Explain the the update statement in sql?
Which constraints we can use while creating database in sql?
What does select count (*) mean in sql?
what is view? : Sql dba
What are the two characteristics of a primary key?
What is nvarchar in sql?
What is trigger types of trigger?
What does the sign mean in sql?
what is a stored procedure? : Sql dba
What is string data type in sql?
What packages are available to pl/sql developers?
When do we use triggers?
