Hello,
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")
)
This table is a bit weird, because I want to store rows related to one
company together. This is why (by Elke's suggestion) I put this CID
(Company ID) as 1st PK column, but then I need another key RID (Record ID)
for convenience of creating relationships.
By the way, will this really cluster rows with equal CID together?
Regards,
Wojtek
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
