=?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <[EMAIL PROTECTED]> writes:
> ALTER TABLE synop
> ADD CONSTRAINT estacoes_fk
> FOREIGN KEY (id_estacao)
> REFERENCES estacoes
> Then I check the DDL and it is like this:
>
> CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao, id_estacao) REFERENCES
> e
Hi all,
I do it in table synop:
ALTER TABLE synop
ADD CONSTRAINT estacoes_fk
FOREIGN KEY (id_estacao)
REFERENCES estacoes
Then I check the DDL and it is like this:
CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao, id_estacao) REFERENCES
estacoes (id_estacao, id_estacao)
- Why id_estac