Re: Foreign Key

Gsong (gsong@aol.com) wrote: : How do you make a foreign key constraint to a table outside of the current : database. Is this possible? : George Song : The North Face It's not possible. The table has to reside in the same database. However, we got around this problem by using a trigger on the table that should contain the foreign key. The trigger called a stored procedure which did the lookup in the referenced table which was not in the same database. -- Stefanie Vario ZenaComp Incorporated svario@zenacomp.com