SAP Knowledge Base Article - Preview

2153707 - Incorrect SQL when default value is removed from a column in Oracle - SAP PD

Symptom

  • PowerDesigner does not add the NULL keyword to the syntax generated when the default value is removed from a column in Oracle. 
  • It currently generates:

alter table tablename
          modify columnname default; 

  • It should generate:

alter table tablename
          modify columnname default NULL;


Read more...

Environment

  • SAP PowerDesigner (PD) 16.5
  • SAP PowerDesigner (PD) 16.6
  • Oracle DBMS

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6 ; Sybase PowerAMC 16.5

Keywords

"column name", CR782479, 782479, CR#782479, ora, standard checks , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

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

Search for additional results

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