Options
Filtered index syntax error: WHERE and WITH clauses swapped
shawnC
Posts: 17
SQL Data Compare 10.2.3.5 (and earlier) generates incorrect syntax for restoring filtered indexes that have a FILLFACTOR clause
The WHERE and WITH clauses are the wrong way around
What is generated:
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?
The WHERE and WITH clauses are the wrong way around
What is generated:
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?
Comments
Thanks!
Using a WITH clause alone works OK. But not when you have a WITH and WHERE clause.
So there's no confusion...