Delete command delets one row or whole table with table defination but tr

What is the difference between DELETE and TRUNCATE?

Question Posted / shilpa

Answer Posted / shilpa

Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between an inner and outer join?

963

What are the steps for performance tuning.

1272

What is a .db file?

928

What is asqueryable?

905

Explain how exception handling is done in advance pl/sql?

958

what is text? : Sql dba

1010

What are the constraints available in sql?

999

what does it mean to have quoted_identifier on? : Sql dba

1101

How many tables can a sql database have?

927

Do prepared statements prevent sql injection?

898

how to convert character strings to numeric values? : Sql dba

1026

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

954

What is mdb stand for?

961

what is union, minus and interact commands? : Sql dba

1123

What does partition by mean in sql?

910