Re: How to say one of a group of columns is required?

Andy Hardy wrote:
>
> Hi,
>
> I have a table with three columns - one or more of which is required.
>
> E.G.
>
> MY_KEY
> MY_LOOKUP1
> MY_LOOKUP2
> MY_LOOKUP3
>
> where at least one of the MY_LOOKUPs is required.
>
> Is there a check constraint for this?

I think that you have to write your own trigger to check this.

Regards
Maciek Received on Fri May 19 2000 - 00:00:00 CDT