CREATE TABLE test.T2 (
col2a INT, col2b INT,
FOREIGN KEY (col2a , col2b) REFERENCES T1(col1a, col1b)
)
The error message is:
Table "T1" not found
The reason for the error is that you are not in test schema (you are
probably in the default PUBLIC schema).
And thus when you point to table T1 H2 interprets that you mean
PUBLIC.T1 because you do not qualify
the reference with schema.
Try
CREATE TABLE test.T2 (
col2a INT, col2b INT,
FOREIGN KEY (col2a , col2b) REFERENCES test.T1(col1a, col1b)
)
- rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
