[webbd]

I’m trying to create tables in a Derby database, using the wizards provided in DB Explorer. I don’t see any way to specify a primary key that consists of more than one column. Do I need to create a multi-column primary key manually using an SQL statement, or is there a way to make one of the wizards do it for me?

Thanks.
Dennis Webb

[Loyal Water]

I don’t see any way to specify a primary key that consists of more than one column.

While adding the colums you can check the Primary Key check box for every column that you want to add as a primary key. (Im referrring to the column wizard window)

[Author]

Posts