Re: Where is a Foreign Key stored?

While primary keys create a unique index to enforce the constraint, foreign keys do not automatically create any index.

If required, such an index should be created "by hand" and be non-unique. When creating this index you can specify the tablespace.

The foreign key constraint itself is stored in the SYSTEM tablespace. Received on Sat Feb 08 1997 - 00:00:00 CST