which will fire first ? Trigger or Constraint

Answer Posted / keshavenas

The sequence of execution as follows :
1) before statement level
2) before row level
3) constraint
4) after row level
5) after statement level

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use pl sql in sql server?

541


What is dml and ddl?

527


What are types of exception?

540


how to use myisamchk to check or repair myisam tables? : Sql dba

509


what is the stuff function and how does it differ from the replace function? : Sql dba

624






how many sql ddl commands are supported by 'mysql'? : Sql dba

528


What do we need to check in database testing?

558


Is sql workbench free?

534


Write a sql select query that only returns each name only once from a table?

572


What are the advantages of stored procedure?

544


List out the acid properties and explain?

563


Why do we use procedures in pl sql?

520


Can we use joins in subquery?

539


What is triggering circuit?

597


What is inner join in sql?

586