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 usage of sql functions?

1144

Can we join tables without foreign key?

957

What is range partitioning?

962

What is the syntax to add a record to a table?

1088

Explain the purpose of %type and %rowtype data types with the example?

988

What does desc stand for?

1065

How are sql commands classified?

1084

What are different types of queries in sql?

1121

Is left join same as join?

988

What are conditional predicates?

1056

Where is all the data on the internet stored?

1007

What is dense_rank in sql?

983

how to rename an existing column in a table? : Sql dba

1016

What are different types of triggers?

1107

What are different types of indexes?

1006