Book a Demo

Author Topic: How in EA work an attribute Check Constraint?  (Read 2984 times)

Ed Dice

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
How in EA work an attribute Check Constraint?
« on: September 27, 2008, 06:19:04 am »
How in EA for a table and its attributes, handle a Check Constraint so it shows up in the Generated DDL?

Such as STATUS_TABLE table with attribute FLAG_IND
and it can only contains values of 'Y' or 'N'.
Thus, have Generated DDL contain:
CONSTRAINT STATUS_TABLE_FLAG_IND_CK CHECK(FLAG_IND IN ('Y', 'N'));
For an Oracle database environment.
Thanks,
Ed Dice
Pensacola FL

jkorman

  • EA User
  • **
  • Posts: 99
  • Karma: +0/-0
    • View Profile
Re: How in EA work an attribute Check Constraint?
« Reply #1 on: September 27, 2008, 06:39:47 am »

Ed Dice

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: How in EA work an attribute Check Constraint?
« Reply #2 on: September 27, 2008, 06:49:01 am »
Thanks.
That looks like what I was looking for.
My attempts so far have gotten the Alter Table add constraint with constraint name but with empty () bowlegs.
At least I know I am in the right area.
Thanks,
Ed

Ed Dice

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: How in EA work an attribute Check Constraint?
« Reply #3 on: September 27, 2008, 07:07:28 am »
 ;D
That worked just great.
Thanks much.
One Atta Boy for you.
Ed ;D