SQL Studio too restrictive - may be considered a bug

[wojtek]

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