On Wed, 15 Jan 2003 11:14:04 -0200, Isaías Cristiano Barroso <isaias(at)unimedjm(dot)com(dot)br>
wrote:
>CREATE TABLE A ( FIELD1 INT PRIMARY KEY, FIELD2 INT PRIMARY KEY);
>ERROR: CREATE TABLE / PRIMARY KEY multiple primary keys for table 'A' are not allowed.
The error message says it all.
>CREATE TABLE A ( FIELD1 INT , FIELD2 INT , PRIMARY KEY(FIELD1, FIELD2);
^
This should work, if you add a ) here --------------------------------+
Servus
Manfred