Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / joe
Delete is DML and truncate is DDl;
both or used to delete the records from the table.
We can rollback the deleted records but we cant when we used truncate.
Delete is faster than truncate
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How do I create a memory optimized filegroup?
What is the difference between joins?
How can we link a sql database to an existing android app?
What is an invalid partition table?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is the difference between jpql and sql?
How to find 3rd highest salary of an employee from the employee table in sql?
What is the usage of the distinct keyword?
What is parameter substitution in sql?
What is an emotional trigger?
Explain the difference between 'between' & 'and' operators in sql
what is text? : Sql dba
What will you get by the cursor attribute sql%found?
Can two tables have same primary key?
What is rownum and rowid?
