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


Please Help Members By Posting Answers For Below Questions

What is the importance of sqlcode and sqlerrm?

1063


What is record data type?

685


Which one is better subquery or joins?

787


Which join condition can be specified using on clause?

712


What are the usages of sql?

756


Can we use having without group by in sql?

739


What is the current version of sql?

742


what is the difference between sql and t-sql? : Transact sql

820


How do you go back in sql?

713


What is the clause we need to add in function body to return variable?

767


How does a trigger work?

729


What is the purpose of the partition table?

771


how to include numeric values in sql statements? : Sql dba

780


Why are sql stored procedures used?

812


What is the largest value that can be stored in a byte data field?

725