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 dialect in sql?

925

What is trigger point?

977

How many developers work on postgresql?

956

What is the maximum number of triggers, you can apply on a single table?

983

What is loop in pl sql?

1019

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1105

What is constant in pl sql?

1005

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1009

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

935

What is not equal in sql?

1088

what are ddl statements in mysql? : Sql dba

1174

What is compound trigger?

1016

What is the need of a partition key?

972

Are subqueries better than joins?

957

What is the difference between jpql and sql?

1074