What is the difference between DELETE and TRUNCATE?
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
Cite the differences between execution of triggers and stored procedures?
Why are indexes and views important to an organization?
How do you truncate?
What is an example of translating a date into julian format?
What is the usage of when clause in trigger?
What are predefined functions in sql?
How do I order by ascending in sql?
Do foreign keys improve performance?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is normalisation and its types?
Explain the update statement in sql
How do I view a sql trace file?
How do you optimize a stored procedure in sql?
What is a behavioral trigger?
What is difference between hql and native sql?