What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20434 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
Truncate will remove the watermark from the table, but the
delete will not.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is the purpose of the partition table?
What is normalisation and its types?
What is a sql statement?
Does a join table need a primary key?
What is the purpose of the sql select top clause?
What are functions in sql?
Where can I learn sql for free?
How we can update the view?
What are the parts of a sql statement?
What is pl/sql language case sensitive?
Can you have more than one trigger on a table?
Does a primary key have to be a number?
What are few of the schema objects that are created using PL/SQL?
List different type of expressions with the example.
