Re: Foreign key constraints

From: Klaus Sonnenleiter <klaus_at_m-machine.com>
Date: Fri, 18 Jun 1999 13:39:16 GMT
Message-ID: <376A4B53.E01247B9@m-machine.com>

In effect yes. You can only create foreign keys referencing primary keys as your target. When you create a primary key, an index is created automatically for you.

Klaus Sonnenleiter
The Media Machine, LLC

Kenneth C Stahl wrote:

> Question: If a foreign key constraint is created for a column in a
> table, is it required that there be an index on that column? One book I
> read suggested that if there isn't an index for the column then there
> may be locking problems when updates occur.
>
> Ken
Received on Fri Jun 18 1999 - 08:39:16 CDT