SqlDbx
You are not logged in.
Pages: 1
Scripting a filtered index ignores filter criteria.
Example:
Script created with Microsoft SQL Server Management Studio:
USE [TestDatabaseName]
GO
/****** Object: Index [UI__testTable_testColumn] Script Date: 01.04.2014 09:46:27 ******/
CREATE UNIQUE NONCLUSTERED INDEX [UI__testTable_testColumn] ON [dbo].[testTable]
(
[testColumn] ASC
)
WHERE ([testColumn] IS NOT NULL)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Script created with SqlDbx Version 3.66:
CREATE UNIQUE INDEX UI__testTable_testColumn
ON dbo.testTable (testColumn)
GO
Last edited by neuli (2014-04-01 03:52:10)
Offline
Thank you for reporting this issue.
Offline
Pages: 1