Skip to Content
0
Jun 12, 2020 at 04:01 PM

PowerDesigner - Where to find constraints in the tool menu

347 Views

Hi, I imported an Oracle schema, which then is being converted to a SQL Server Schema.

In my preview, I see:

create table HO ( HO_ID numeric(9) not null,

PROVINCE varchar(2) null, CITY varchar(10) null,

TRIAL_HO_IND varchar(1) null,

constraint HO_PK primary key nonclustered (HO_ID),

constraint HO_CHECK_DATE check (nvl(expiry_date,effective_date) >= effective_date) )

go

Where do I find the 2nd Constraint - HO_CHECK_DATE? I am not able to find it anywhere in the properties...