rr-wfm/MSBuild.Sdk.SqlProj

SqlServer.Rules has false positive: SRP0020

ErikEJ opened this issue · 1 comments

https://github.com/tcartwright/SqlServer.Rules/blob/master/docs/Performance/SRP0020.md

CREATE TABLE [dbo].[OI] (
    [Id]         INT                                         IDENTITY (1, 1) NOT NULL,
    [Version]                   INT                                         NOT NULL,
    CONSTRAINT [PK_OI] PRIMARY KEY NONCLUSTERED ([Id]),
    CONSTRAINT [CI_OI] UNIQUE CLUSTERED ([Version] ASC)
)

Rule was not looking at unique constraints, only indexes