Delete command removes records one at a time and logs into the transaction log.

It can be used with or without where clause.

The records can be rolled back.

It activates trigger.

It doesn’t reset the identity of the column.