Subject Primary Key
Author drstanl
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