Topic
  • 2 replies
  • Latest Post - ‏2013-02-27T08:45:13Z by MarkOrmos
MarkOrmos
MarkOrmos
20 Posts

Pinned topic Check constraint for a single column

‏2013-02-26T15:18:51Z |
Hi,

I would like to add a check constraint to a single column, but I can't see an option for it.
For instance the column YN_Column can only accept the values Y or N.

How can I do it? Can you help me with it?

Thank you for your help!
Best regards
Mark
Updated on 2013-02-27T08:45:13Z at 2013-02-27T08:45:13Z by MarkOrmos
  • SystemAdmin
    SystemAdmin
    374 Posts

    Re: Check constraint for a single column

    ‏2013-02-26T16:19:52Z  
    Hi, Mark.

    You want to add a check constraint to the table which contains the column. Then enter the check condition as the expression.

    Don
  • MarkOrmos
    MarkOrmos
    20 Posts

    Re: Check constraint for a single column

    ‏2013-02-27T08:45:13Z  
    Hi, Mark.

    You want to add a check constraint to the table which contains the column. Then enter the check condition as the expression.

    Don
    Thank you Don!