The WHERE and WITH clauses are the wrong way around
What is generated:
- Code: Select all
CREATE UNIQUE NONCLUSTERED INDEX [IXU_Foo] ON [Data].[Bar] ([BarID], [BarName]) WITH (FILLFACTOR=90) WHERE ([BarName] IS NOT NULL) ON [PRIMARY]
This means that I have to use SQL Compare to fix the schema after synchronizing data and can't trust SQL Data Compare
Can this be fixed please?