Integrity Checks for SQL DDL Code

SonarQube Server / Community Build
1

Version: Enterprise Edition - Version 10.4.1

Hi there,

I’m fairly new to SonarQube and was wondering if SonarQube has the ability to check SQL Server Database DDL scripts for Primary/Foreign Keys for example and other integrity checks within tables; to see if these keys are present and referenced in other tables and if not, flag them up etc.

If it doesn’t have such capabilities, could anyone kindly suggest what methods they would use to check for such potential integrity issues?

2

Hi,
Welcome to the community!

We have support for PL/SQL and T-SQL in commercial editions, but nothing for SQL Server DDL scripts.

 
Ann

1 Like