Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

check constraint in Data Modeler

ZiutOct 5 2009 — edited Oct 15 2009
Hi
I have a problem with merging two logical models.
in first I have a table with column ranking number(2),
in second model I modify this column:

ranking varchar2(10) default 'A'

and create check constraint ranking_ch:

ranking..... check ('A', 'B',.....)

Then I compare models I have only

alter table....
modify ranking varchar2(10) default 'A'

but I have not constraint ranking_ch.

Why?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2009
Added on Oct 5 2009
4 comments
2,328 views