Hello.

Suppose that I know a relation in a database. I have in 4 variables the following info: Parent table name, Child table name, parent index and child index.

I want to duplicate the relation in another database (assuming the parent and child tables exists, and they have the same indexes).

The command I need is ALTER TABLE, but I can't figure out how to complete the command.

In particular, I need the clauses noted below:

ALTER TABLE child_table ADD FOREIGN KEY clause TAG clause FOR clause

Can anyone help?