2437850 - The check constraint of nullable columns can not be modified - SAP PD

• When a column is not mandatory and a check constraint expression has been defined, SAP PD generates the following syntax:

CREATE TABLE table_name (
column_name data_type
CONSTRAINT constraint_name CHECK (column_name is null or (expression))
);

• The constraint expression can be defined either on the Additional Checks tab, or on the Expression tab of validation rules specified on the Rules tab.
• It should be possible to remove the column_name is null constraint expression and have SAP PD to generate:

CREATE TABLE table_name (
column_name data_type
CONSTRAINT constraint_name CHECK (expression)
);

• SAP PowerDesigner (PD) 16.6
• Oracle DBMS

null, mandatory, customized, changed, default, 806125, CR806125, CR#806125 , KBA , BC-SYB-PD , PowerDesigner , Problem