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?
>

• Next in forum: Re: Index on two columns doesn't allow NULL in both - HELP!
• Prev in forum: Re: Index on two columns doesn't allow NULL in both - HELP!
• Thread view: Re: Index on two columns doesn't allow NULL in both - HELP!

[Reply to this message]