Interested to Buy Any Domain ? << Click Here >> for more details...
how many triggers we can create on a table
- 11 Answers
- 52597 Views
- G2 Technology, TCS, I also Faced
- E-Mail Answers
Answer Posted / samir
You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.
You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.
Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.
This information is available in Books Online
under "Triggers".
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Why we use bulk collect in oracle?
What is oracle host variable?
Why is oracle used?
What is the purpose of save points in oracle database?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
what happened to the global index when I truncate the data in one of the partition?
How to create a temporary table in oracle?
What is procedure overloading in oracle?
What would you do with an in-doubt distributed transaction?
What is the difference between I and G in Oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
interview questions with answer for cts
How to delete a column in an existing table in oracle?
What is an oracle transaction?
How do I limit the number of rows returned by an oracle query after ordering?
