Additional Exception for T-SQL Rule RSPEC-4413 - "A primary key..."

Rules and Languages
1

Related to rule RSPEC-4413 “A primary key should be specified during table creation”, there is another valid exception to not enforce a Primary Key Colum. Which would be a table variable.

DECLARE @EmployeeName TABLE
(last_name VARCHAR(42) NOT NULL);

Thank you.

2

Hi,

Can you help me dot my 'i’s by providing your analysis context? SonarQube Cloud? SonarQube Server / Community Build version?

 
Thx,
Ann

3

Hi Ann

It’s relevant for SonarQube Cloud and Server and the T-SQL language.

Thank you.

Chris

6

Hello @ChrisRo89,

You mention RSPEC-4413 but you post suggest that you meant RSPEC-1614.

Assuming you are talking about RSPEC-1614, I was not able to reproduce the false positive.

Are you suggesting to mention this exception in the rule description?
Or are you getting a false positive for this scenario?

Thanks,