0

Does Java DB (Derby) as set up in NetBeans allow the use of foreign keys. If so then how do you designate a particular column as a foreign key? It seems strange to me that when setting up a table's column there is a checkbox for clicking if there is a primary key but not a checkbox for clicking foreign keys.

Daron
  • 329
  • 1
  • 4
  • 24

1 Answers1

1

You need a primary key on the main table so, its key can be used to refer to the foreign constraint. See this thread. Derby foreign key constraint

Community
  • 1
  • 1
Barry McGillin
  • 465
  • 5
  • 11