SqlServer.Rules has false positive: SRP0020
ErikEJ opened this issue · 1 comments
ErikEJ commented
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)
)
ErikEJ commented
Rule was not looking at unique constraints, only indexes