What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 14435 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
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Can we use the cursor's to create the collection in PL/SQL?
When should I use nosql database?
Why schema is used in sql?
What is dbo in sql?
Which is better stored procedure or query?
Can we insert data in view?
Why we use stored procedure instead of query?
What are the main features of cursor?
What is a system versioned table?
How do I remove all records from a table?
Explain the difference in execution of triggers and stored procedures?
What is lookup table in sql?
How do you respond to dementia behavior?
