On 30 September 2011 11:20, J.V. <jvsrvcs(at)gmail(dot)com> wrote:
> For tables that already exist and have a foreign key relationship, is there
> an equivalent alter statement for the statement below?
>
> Does this mean that if table xxx.id primary key value changes, the foreign
> key value will change as well?
They do if you tell them to CASCADE on UPDATE.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.