Illustrates the Delete commands

Question

Illustrates the Delete commands.

Answer 1

Delete:

• 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.