Skip to content

Multiple column FKs #207

@nguyenk

Description

@nguyenk

Let's say I have a Table A with composit PK. I Have another Table B that need to point on Table A using 2 local columns.

Basic SQL would be :

ALTER TABLE B ADD CONSTRAINT B_TO_A FOREIGN KEY ( FK_COL_1 , FK_COL_2 ) REFERENCES B ( PK_COL_1 , PK_COL_2 )

I'm getting error :

TDBMException : PropertyDescriptor for B.FK_COL_1 not found in A

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions