What are the challenges you face when working across database platforms? Take the survey
Options

Nonclustered Index not detecting Where is not null

shawn.mayershawn.mayer Posts: 3
edited November 25, 2014 3:22PM in SQL Compare 11
I have an index that is created like so:
CREATE UNIQUE NONCLUSTERED INDEX [UNQ_table] ON [dbo]. ([column]) WHERE ([column] IS NOT NULL)

SQL Compare doesn't seem to be detecting the where is not null part and says it should be replaced with:
CREATE UNIQUE NONCLUSTERED INDEX [UNQ_table] ON [dbo]. ([column])

Which fails, because several of the rows are null.

I dropped the index on both databases being compared and recreated them to verify they were the same.

Comments

Sign In or Register to comment.