which will fire first ? Trigger or Constraint

Answer Posted / vanujit

sequence of execution is as follows

Before statement level trigger
Before row level trigger
After row level trigger
Constraint
After statement level trigger

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do we use triggers?

596


What is a natural join?

525


Does sqlite need a server?

552


What is sap sql anywhere?

543


What has stored procedures in sql?

611






What is a constraint?

574


Which is faster truncate or drop?

568


What is materialized view in sql?

471


What is difference between inner join and self join?

606


Are sql database names case sensitive?

511


What are the constraints available in sql?

592


Write a unique difference between a function and a stored procedure.

541


What are the different types of joins in sql?

589


List the different type of joins?

582


What is the difference between sql and isql*plus?

522