None of these can be put on views, which are really just stored SELECT
statments based on other tables. However, if you insert/update/delete
through the view, the constraints, rules, defaults and triggers on the
underlying tables will be applied.
SQL Server MVP
Quote:> I'm reviewing constraints, rules, defaults, and triggers,
> and I'm wondering if any of them can be applied to a view
> (not the underlying table).