Truncate will remove the watermark from the table, but the delete will no

What is the difference between DELETE and TRUNCATE?

Question Posted / gourvendra singh

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

Please Help Members By Posting Answers For Below Questions

how to shutdown mysql server? : Sql dba

1107

What is over () in sql?

969

What is clustered and nonclustered index in sql?

944

Can we alter stored procedure?

993

How to move files from one directory to another in pl sql?

1196

How do I view tables in sql developer?

956

Can a trigger call a stored procedure?

1075

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

977

Are sql connections encrypted?

1033

What is pl sql block in dbms?

1010

Which is better stored procedure or query?

959

What is sql trigger example?

1071

Can you upgrade sql express to full sql?

1075

What are sql constraints?

1180

What is time based sql injection?

963