RE: SQL Studio too restrictive - may be considered a bug

[Daniel Dittmar]

> 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
daniel.dittmar@stripped
http://www.sapdb.org/