What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 14356 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 does the t-sql command ident_incr does? : Transact sql
How do you optimize a stored procedure query?
What is scalar function?
What are the rules to be applied to nulls whilst doing comparisons?
When is the explicit cursor used ?
What does fetching a cursor do?
How many types of cursors supported in pl/sql?
What are all the ddl commands?
What view means?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is union?
What is file based approach?
What is primary key and unique key?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Can you have a foreign key without a primary key?
