SQLStudio and ForeignKeys

[Sven K�hler]

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