which will fire first ? Trigger or Constraint

Answer Posted / p.j.mohana rao

Constraint will fire first bcz these are restrict the
column value
before enter into the table these value is valid or not
that why constrint will fire first

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How show all rows in sql?

594


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

800


What type of join is sql join?

518


What is record variable?

541


what are different types of keys in sql?

597






Can we use update in sql function?

564


What is the difference between a subquery and a join?

520


What is normalisation in sql?

537


How do I count duplicates in sql?

534


What is row_number () in sql?

529


What is structural independence and why is it important?

538


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

542


Why plvtab is considered as the easiest way to access the pl/sql table?

605


What is offset in sql query?

587


What is pragma in sql?

609