What is the difference between DELETE and TRUNCATE?
Answer Posted / althaf
the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is informix sql?
what is schema? : Sql dba
What is the use of sqlerrd 3?
What is lexical units in pl sql?
What is sql clause?
What does joining a thread mean?
Why do we need sharding?
What are the commands used in sql?
what are the authentication modes in sql server? How can it be changed? : 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
How to raise user-defined exception with custom sqlerrm ?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
can sql servers linked to other servers like oracle? : Sql dba
What is the purpose of primary key?
What is left join example?