Home

Deprecated system tables and views should not be used

Rule description

  • Deprecated system tables and views should not be used

 

Non-compliant Code Example

Create Procedure TestProc3
As
BEGIN
	SELECT col.name columnName
	FROM syscolumns   --Non compliant code
	WHERE col.name like '%name' 
END;
GO
Visual Expert 2020
 VETSQLRULE24