Try this,

CREATE TABLE MyNewTable
(
ID1 VARCHAR(16) NOT NULL,
D1 VARCHAR(8) NOT NULL,
D2 VARCHAR(8) NOT NULL,
V1 FLOAT,
CONSTRAINT PK_MyNewTable PRIMARY KEY (ID1, D2, D3)
);

----- Original Message -----
From: "drstanl" <drstanl@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, January 20, 2004 10:37 AM
Subject: [firebird-support] Primary Key


> 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?
>
> Thanks,
> -- Stan
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>
>