Hi Sven, there was an error in displaying the "indexed columns"-list in the foreign key dialog in older SQL Studio Versions. Maybe you just install the newest version.
regards Wolfgang -----Original Message----- From: Sven K�hler [mailto:skoehler@;upb.de] Sent: Mittwoch, 6. November 2002 13:23 To: [EMAIL PROTECTED] Subject: SQLStudio and ForeignKeys create table t1(id1 serial, foo1 varchar(255), primary key (id1)) // create table t2(id2 serial, id1ref fixed(10), foo2 varchar(255), primary key(id2)) // alter table t2 foreign key (id1ref) references t1(id1) the above works perfectly. but if i try to use the GUI to setup a table like t2, i'm unabled to select the column t1.id2 as a reference for foreign key. it isn't listed in the "indexed columns"-list. creating an index on column td1.id1 doesn't work. it's already indexed because of the primary-key-definition. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
