Subject | could not find UNIQUE INDEX with specified columns |
---|---|
Author | troller507 |
Post date | 2008-10-15T13:39:33Z |
Hi
I can't understand the error message which occures when I try to
create the following table:
CREATE TABLE test (field1 integer, field2 char(1024), field3 integer,
PRIMARY KEY (field1), FOREIGN KEY (field3) REFERENCES test(field1))
What do I miss?
Regards
Joe
I can't understand the error message which occures when I try to
create the following table:
CREATE TABLE test (field1 integer, field2 char(1024), field3 integer,
PRIMARY KEY (field1), FOREIGN KEY (field3) REFERENCES test(field1))
What do I miss?
Regards
Joe