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

What is a schema? How is it useful in sql servers?

603


What are different clauses used in sql?

601


Which one is faster ienumerable or iqueryable?

495


How to use transactions efficiently : transact sql

554


What is sql data?

558






how to start mysql server? : Sql dba

624


how to check server status with 'mysqladmin'? : Sql dba

582


What is auto increment?

586


What are the various restrictions imposed on view in terms of dml?

531


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

816


How many commands are in sql?

537


Does inner join remove duplicates?

530


Define union, minus, union all, intersect ?

560


Write the command to remove all players named sachin from the players table.

750


Does sql full backup truncate logs?

539