Answer Posted / gourvendra singh

This is for the people who says 'No' to the answer no 7.
As i still believe that it totally depends upon the timings of the trigger.
Consider the below example:
Example1: If i created a trigger as Before insert/update/delete on a table. Whenever user will perform any DML operation on the said table, the trigger will always executes first then it will check the constraint.
Example2: If I created a trigger as After Insert/Update/Delete on a table. Whenever user will perform a DML operation on the said table, the constraint will execute first then the trigger will be executed.
Please mail me if I am wrong on the below mail id:
raviindian2114@gmail.com

How can you fetch common records from two tables?

1059

---

what is the difference between join and union? : Sql dba

1111

---

What is oracle pl sql developer?

978

---

How to know the last executed procedure?

1091

---

how can we find the number of rows in a table using mysql? : Sql dba

1082

---

what are different types of collation sensitivity? : Sql dba

1064

---

Is big data nosql?

942

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

---

What is the maximum number of columns in sql table?

1167

---

What are sql constraints?

1172

---

Does pl sql work in mysql?

976

---

What are different clauses used in sql?

1112

---

How do I view tables in sql developer?

934

---

What is the difference between alter trigger and drop trigger statements?

1101

---

What are sql triggers used for?

993

---