Re: Database design question

From: Michael Gaab <>
Date: Mon, 26 Jun 2006 11:25:28 -0600
Message-ID: <>

<> wrote in message
>I have a database design questions. How can we specify one of two
> columns in a table should be not null? In other words, if one column is
> null then another column should not be null.

My first thought is the following, either at the dbms level or application level.

if( tableA.group_id == null)

    tableB.user_id = IDGenerator();


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Received on Mon Jun 26 2006 - 19:25:28 CEST

Original text of this message