Database wide constraint?
From: Emily Jones <emilyj_at_hotmail.com>
Date: Wed, 9 Aug 2006 08:08:56 +0100
Message-ID: <44d98a00$0$641$5a6aecb4_at_news.aaisp.net.uk>
I have table 1, whose primary key may be used in table 2 table 3 .... table n, as a foreign key.
Date: Wed, 9 Aug 2006 08:08:56 +0100
Message-ID: <44d98a00$0$641$5a6aecb4_at_news.aaisp.net.uk>
I have table 1, whose primary key may be used in table 2 table 3 .... table n, as a foreign key.
Is there any constraint that can applied, hopefully once and in one place, that ensures that for any particular row in table 1, it's value is used in only one other table (though it may be used many times in that one other table)?
Thanks, Emily
Received on Wed Aug 09 2006 - 09:08:56 CEST