> It's not possible to create table like this with SQL Studio.
> A member of PK
> cannot be marked UNIQUE.
>
> CREATE TABLE "BAR"
> (
> "CID" Integer NOT NULL,
> "RID" Integer NOT NULL Unique,
> "RID_FOO" Integer NOT NULL,
> "SOME_TEXT" Varchar (256),
> PRIMARY KEY ("CID", "RID")
> )
What error was returned? I could issue that command in SQLStudio (both in Oracle and
internal mode) and the table was created.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
