which will fire first ? Trigger or Constraint

Answer Posted / rajesh

if it is before insert or update trigger, trigger wil fire
first, if it is after insert or upadate constraints will
execute first.

Is This Answer Correct ?    26 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to rename an existing table in mysql? : Sql dba

726


What is a string data type in sql?

718


What is sql basics?

782


What is sql prepared statement?

737


Write a sql query to convert all character to uppercase after hypen.

1168






What is sql and db2?

729


How do I run a sql query in pgadmin 4?

718


Why do we create stored procedures & functions in pl/sql and how are they different?

692


what is cursor. write example of it. What are the attributes of cursor.

976


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

765


What is execute immediate?

719


How we can update the view?

811


What are user defined functions?

759


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

850


Can I learn sql in a week?

753