Sunday, May 09, 2010

JavaDB Many-To-Many SQL Syntax

create table schema.table name(
column_id column_type (column_parameter(s)) references schema.primary_table_name (primary_table_column)
.
.
.
primary key (column_id, column_id)
)

foreign keys must be the same type and size as their primary key counterparts.

No comments: