Subject | sql to check if a row has been used in related tables? |
---|---|
Author | wang960 |
Post date | 2007-03-26T11:21:43Z |
Hi,
I have a table called Item with keyfield itemno, and there are many
tables use the itemno as foreign key, is there a generic way to check
if a certain itemno already exists in one of related tables? Thanks.
I have a table called Item with keyfield itemno, and there are many
tables use the itemno as foreign key, is there a generic way to check
if a certain itemno already exists in one of related tables? Thanks.