Retour
-
Titre
My check constraint appears as table constraint. How do I get that to be a column level constraint instead? -
Description
There is an existing Validation Rule of Check Constraint at the table level when I reverse engineer using a script or copy/paste a table into another model. But it is not attached to the particular column and when I generate the script out of erwin, the check constraint is not there in the generated script (oracle).CREATE TABLE parts (part_id NUMBER GENERATED BY DEFAULT AS IDENTITY,part_name VARCHAR2(255) NOT NULL,buy_price NUMBER(9,2) ,PRIMARY KEY(part_id));ALTER TABLE parts ADD (CONSTRAINT chk_partsCHECK (buy_price > 0)); -
Cause
diagramming -
Résolution
Your SQL DDL is for a table constraint. For a column constraint a validation rule also needs to be created. This SQL will do that:CREATE TABLE parts(part_id NUMBER GENERATED BY DEFAULTAS IDENTITY ( ) NOT NULL ,part_name VARCHAR2(255) NOT NULL ,buy_price NUMBER(9,2) NULL);CREATE UNIQUE INDEX XPKparts ON parts(part_id ASC);ALTER TABLE partsADD CONSTRAINT XPKparts PRIMARY KEY (part_id);ALTER TABLE partsMODIFY buy_price CONSTRAINT Validation_Rule_126_506144642 CHECK (buy_price > 0);The way I got that to generate was by changing Check Constraint to Alter in my model 2_2021 R1 check constraint example.erwin.
-
Pièces jointes