DF107: A primary key is not specified.

The topic describes the DF107 T-SQL code analysis rule.

Category

STYLE

Message

A primary key is not specified.

Description

It is recommended to define a primary key during table creation to ensure data integrity and facilitate data retrieval.

Noncompliant code example

CREATE TABLE dbo.DemoTable (
  id INT NOT NULL
 ,Code NVARCHAR(128) NOT NULL
)
GO

ALTER TABLE dbo.DemoTable
ADD CONSTRAINT PK PRIMARY KEY (id)
GO

Compliant solution

CREATE TABLE dbo.DemoTable (
  id INT NOT NULL PRIMARY KEY
 ,Code NVARCHAR(128) NOT NULL
)
GO

CREATE TABLE dbo.DemoTable (
  id INT NOT NULL
 ,Code NVARCHAR(128) NOT NULL
 ,CONSTRAINT pk PRIMARY KEY (id)
)
GO