Sorry if this is a “supid-noob” question but …
I did a reverse engineer of an Oracle 11gr2 schema and after it was complete did a ‘Generate Change Script’ comparing the newly created model with the same schema I just reverse-engineered. I wasn’t expecting any differences but it generated “ALTER TABLE xxx MODIFY (xxx_pk_col NOT NULL)” for the primary key columns.
Is this something I did wrong with the reverse-engineer or something I did wrong with the “Generate Change Script”?
How do I prevent this from happening? We have a standard where we don’t create explicit NN constraints on our PK columns so I really don’t want the “Generate Change Script” to raise this false-positive.