Re: Change key primary for key foreign

I created one table so:

CREATE TABLE clima (
    city     char(80),
    cprc     int,
);

And have other table so:

CREATE TABLE city (
    name            char(80),
    other_thing     int,
);

But now I want the table clima receive name table city as foreign key. understand?
Sorry my bad english.


Em terça-feira, 18 de setembro de 2012 17h37min59s UTC-3, Guilherme Rodrigues  escreveu:
> Hello. I want to change one table already created. Where the comand? thank you.