Hello Gerd,
you sent me the table definitions and the alter statement
in the meantime :
> the referenced column was not
> indext explicit, but as a key in the refrenced table is it
> implicit indext.
>
> CREATE TABLE "GERDDBA"."TESTTABLE_C"
> (
> "AKZ" Varchar (17) ASCII,
> "FK_ID" Varchar (7) ASCII,
> "ATT1" Varchar (7) ASCII,
> "ATTn" Varchar (7) ASCII,
> PRIMARY KEY ("AKZ")
> )
>
> CREATE TABLE "GERDDBA"."TESTTABLE_L"
> (
> "FK_ID" Varchar (7) ASCII,
> "ATT_L1" Varchar (7) ASCII,
> "ATT_Ln" Varchar (7) ASCII,
> PRIMARY KEY ("FK_ID")
> )
>
> Now i tried to define a foreign key for the TESTTABLE_C in
> the Ref. Integrity register.
> After dropping the TESTTABLE_L to the Referenced table popup
> i can't see the
> FK_ID Attribute. Wondering about that i think i do the same
> with a SQL statement :
>
> alter table TESTTABLE_C foreign key FK_TEST (FK_ID)
> references TESTTABLE_L (FK_ID) on delete restrict
>
> and oops it work's !
you ran into a known bug in SQLStudio 7.4.3.6 :
the 'referenced table' popup doesn't show any columns
if the sysdba (the principal SQL user which is created with a
db instance) is not named 'dba' (i guess its name in your case
is 'gerddba').
This has already been fixed and will be available with the next
release of SQL Studio.
regards,
Markus Stausberg
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
