Thursday, May 15, 2008

Truncate and Delete1

1. For truncate command, trigger will not get fired, but for Delete Command, Trigger will get fired.

2. Truncate Is the DDL command whereas Delete is the DML command

3.Once the truncate command is issued, Transactions can't be rolled back whereas transactions can be rolled back for Delete command.

No comments:

Post a Comment