Home
Constraint names should comply with a naming convention
Rule description
- Constraint names should comply with a naming convention
Non-compliant Code Example
Create TABLE EMPLOYEE ( 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) --Non compliant code );
Compliant Code Example
Create TABLE EMPLOYEE ( EMP_ID number(10) NOT NULL, FIRSTNAME NVARCHAR2(75), LASTNAME NVARCHAR2(75), DEPT_ID int, ADDRESS NVARCHAR2(250) NOT NULL, CONSTRAINT pk_employee PRIMARY KEY (EMP_ID) --Compliant code );