SAP Knowledge Base Article - Preview

2561756 - Cannot generate or reverse the VALIDATE NOVALIDATE state of column constraints - SAP PD

Symptom

  • It is not possible to generate a SQL script to create a constraint on an Oracle column using the VALIDATE / NOVALIDATE keyword defining the constraint state.
  • It is also not reversed.
  • Examples of appropriate syntax:

ALTER TABLE table MODIFY column NOT NULL NOVALIDATE;

ALTER TABLE table 
ADD CHECK (column IS NOT NULL) NOVALIDATE;

ALTER TABLE table

ADD CONSTRAINT constraint CHECK (column IS NOT NULL) NOVALIDATE;


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • Oracle DBMS

Product

SAP PowerDesigner 16.6

Keywords

RE, "reverse engineering", enable, disable, 811790, CR811790, CR#811790 , 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.