2010605 - Change column to NULL/not NULL should generate ALTER statement – SAP PD 16.5

Modifying an existing database schema to reflect new changes in your Physical Data Model (PDM).
A table column is made mandatory to reject null values when the column contains no null values.
A table column is made non-mandatory to accept null values.
PostgreSQL DBMS uses the ALTER TABLE statement to allow null values or to reject null values for a column:

ALTER TABLE table
ALTER [ COLUMN ] column { SET | DROP } NOT NULL

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP PowerDesigner 16.5 ; Sybase PowerAMC 16.5

modify, alter, CR762916, 762916 , KBA , BC-SYB-PD , PowerDesigner , Product Enhancement

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

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