How many triggers can be implemented for a table?
Answer Posted / hairreddy
we can create more no of triggers on a single table but we can apply 12 different type of triggers only on a table
before -- for this table level and row level (insert/update/delete)-----total 6
after-- for this table level and row level (insert/update/delete)-----total 6
total 12 different triggers we can write on a table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the importance of sqlcode and sqlerrm?
What is record data type?
Which one is better subquery or joins?
Which join condition can be specified using on clause?
What are the usages of sql?
Can we use having without group by in sql?
What is the current version of sql?
what is the difference between sql and t-sql? : Transact sql
How do you go back in sql?
What is the clause we need to add in function body to return variable?
How does a trigger work?
What is the purpose of the partition table?
how to include numeric values in sql statements? : Sql dba
Why are sql stored procedures used?
What is the largest value that can be stored in a byte data field?