Foreing Keys

[Former Member]

How do you set the relationship between tables? (foreign keys) Can you accomplish this relationship through the Java Dictionary?

Regards,

José

Message was edited by: Jose Maria Salas Correa

[former_member441228 · Accepted solution]

As far as I know you can't; the 'dictionary explorer' simply doesn't support defining inter-table dependencies.

[Former Member]

Hi

In the wizard when u ckick create DDL Script

it will create the script for ur DataBase u can

customize the script and execute it

Regards,

Kavitha

[Former Member]

Hi Jose,

This functionality is not available in Java dictionary. But, you can manually write Alter table SQL statements to add foreign key relationships in your database directly. This should not be the approach. But if you need anyhow then you can do like this.

Regards,

Bhavik