|
Posted by Dan Guzman on 12/23/05 04:03
> I don't think the view forces the constraint onto the table. Is this
> correct?
SQL Server automatically maintains the view index to reflect underlying
table changes. This will have the effect of a unique constraint that
ignores null values. Duplicate non-null values will not be allowed in the
underlying table.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Doug" <drmiller100@hotmail.com> wrote in message
news:1135296417.507570.119610@f14g2000cwb.googlegroups.com...
> Hmmmm.......
>
> I don't think the view forces the constraint onto the table. Is this
> correct?
>
[Back to original message]
|