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


Please Help Members By Posting Answers For Below Questions

Is sql a microsoft product?

690


What is sql query limit?

697


what are the advantages of mysql in comparison to oracle? : Sql dba

703


What are all different types of collation sensitivity?

733


how do you login to mysql using unix shell? : Sql dba

740






What is data control language (dcl)?

785


How do you determine the current isolation level? : Transact sql

748


What is dba in sql? : SQL DBA

736


Explain dml and ddl?

733


Can you inner join the same table?

705


explain the options of myisamchk to improve the performance of a table. : Sql dba

719


What is use of term?

788


What are local and global variables and their differences?

802


How to start oracle sql developer?

749


Which sql most popular?

724