Re: Adding foreign keys

Andreas Pflug wrote:

> Trent Oliphant wrote:
>
>> The add constraint foreign key dialog does not appear
>> to be working correctly. It doesn't offer any column
>> choices in the 'referencing' drop down box in the
>> columns tab. I have a table selected that has the
>> primary key column I am trying to reference.
>
>
> I can't reproduce this. This sounds like what happens when the tables
> don't have pks.
>

This is strange, I still can't get the columns to show up in the schema
that I am working in.

However, if I copy the table definitions to a query window in another
database I am able to create
the tables and if I add a foreign key the columns show up as I would
expect them to. (I am not using a public schema in either database but
the same schema name as the login name).

Any ideas as to what I may have set wrong in my current schema that
would cause this behavior? Something with permissions or anything else.
I can't get ANY tables to show their columns in the drop down list for
any other table in the schema. I have ended up just writing the SQL to
create the foreign key constraint - which isn't that big of a deal -
this behavior just seemed really strange.

Thanks for your help.

Trent Oliphant