Home
A primary key should be specified during table creation
Rule description
- A primary key should be specified during table creation
Non-compliant Code Example
Create TABLE EMPLOYEE --Non compliant code (Table definition without primary key)
(
ID number(10) NOT NULL,
FIRSTNAME NVARCHAR2(75),
LASTNAME NVARCHAR2(75),
DEPT_ID int,
ADDRESS NVARCHAR2(250) NOT NULL
);
Compliant Code Example
Create TABLE EMPLOYEE --Compliant code (Table definition with primary key)
(
EMP_ID number(10) NOT NULL,
FIRSTNAME NVARCHAR2(75),
LASTNAME NVARCHAR2(75),
DEPT_ID int,
ADDRESS NVARCHAR2(250) NOT NULL,
CONSTRAINT employee_pk PRIMARY KEY (EMP_ID)
);