SqlDbx Forum

neuli

Member

Bug: Filtered Index scripting

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)

sqldbxhelp

Administrator

Re: Bug: Filtered Index scripting

Thank you for reporting this issue.