In order to alter your tables that already have primary or foreign key constraints, you can simplye prepare the drop and add constraint scripts with the help of SQL Enterprise Manager.
Simply select the tables you want to alter and by right clicking,
Read More