A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to SQLite
Foreign key references are ignored. This problem does not arise.
DB2
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to DB2
none
MS Access
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to MS Access
none
PostgreSQL
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to PostgreSQL
none
Oracle
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to Oracle
none
MS SQL Server
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to MS SQL Server
none
MySQL
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to MySQL
It's an old tart - it will let you reference any old rubbish.
Sybase
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.
Specific to Sybase
none
Mimer SQL
A foreign key should refer to a candidate key in
some table. This is usually the primary key but may be a
field (or list of fields) specified as UNIQUE.