Home

Rule description

• A primary key should be specified during table creation

Non-compliant Code Example

CREATE TABLE Employee
(
  employee_id int NOT NULL, --Non compliant code
  first_name VARCHAR(42) NOT NULL,
  last_name VARCHAR(42) NOT NULL
);

Compliant Code Example

CREATE TABLE Employee
(
  employee_id int IDENTITY(1,1) PRIMARY KEY, --Compliant code
  first_name VARCHAR(42) NOT NULL,
  last_name VARCHAR(42) NOT NULL
);