--- In firebird-support@yahoogroups.com, "drstanl" <drstanl@v...>
wrote:

> Hi all,
>
> In a CREATE TABLE statement, what is the proper syntax to make

the

> first three (of four) columns the Primary Key?
>
> So far I have the following:
>
> CREATE TABLE MyNewTable (ID1 VARCHAR(16) NOT NULL PRIMARY KEY,
> D1 VARCHAR(8) NOT NULL, D2 VARCHAR(8) NOT NULL, V1 FLOAT);
>
> This, of course, creates my (non-unique!) first column as the
> Primary Key. How do I get the next two columns in there?

MANUAL - book which real programmer reads only after second step on
the same rake (C).

Stan,

CREATE TABLE MyNewTable
(ID1 VARCHAR(16) NOT NULL,
D1 VARCHAR(8) NOT NULL,
D2 VARCHAR(8) NOT NULL,
V1 FLOAT,
Constraint MyNewTable_PK PRIMARY KEY (ID1, D1, D2)
);

Should I tell about multisegment Foreign Keys in advance or you'll
look into Language Reference? ;)

Best regards,
Alexander.