>
> I have 2 tables:
>
> DEPARTMENTS(Code, Name)
> EMPLOYEES(Code, Name, Address, DEPARTMENT (foreign key))
>
> I want to merge 2 departments(from A into B) and udpate all foreign
> keys tables. How I do?

UPDATE EMPLOYEES SET DEPARTMENT = 'B' WHERE DEPARTMENT = 'A';

Adam