Subject | Primary Key |
---|---|
Author | drstanl |
Post date | 2004-01-20T16:37:54Z |
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
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