SAP Knowledge Base Article - Preview

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

Symptom

  • 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)
);


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • Oracle DBMS

Product

SAP PowerDesigner all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.