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.