Geek asks and answers

View Triggers

Can we write triggers on a view in sql server. If so, when will these triggers be launched? Suppose I write an insert trigger in a view, will it fire when I insert data into the base table from which the view was built?

+3
source share
1 answer

Yes, you can create triggers on views. (Since at least SQL Server 2000. )

If you create a trigger on a view, it will not trigger insertions into the base table. If you want something to happen when you insert data into the base table, create a trigger in the base table.

INSTEAD OF .

, ?

+4

More articles:


All Articles