有没有会的解决一下吧

/帐套修改步骤/

/以下为UFSystem修改内容/
/删除约束/
alter table dbo.UA_log drop constraint FK__UA_Log__cUser_Id__6AEFE058;
alter table dbo.UA_Log drop constraint FK__UA_Log__cAcc_Id__4F7CD00D;
alter table dbo.UA_Role drop constraint FK__UA_Role__cUser_Id;
alter table dbo.ua_account_sub drop constraint FK__UA_Accoun__cAcc___44FF419A;
alter table dbo.UA_Period drop constraint FK__UA_Period__cAcc___45F365D3;
/删除约束/

/修改用户表/
UPDATE Ua_user SET cUser_Id = '171' WHERE cUser_Id = '170';
UPDATE Ua_user SET cUser_Name = '段越' WHERE cUser_Name = '乔宇鹏';
UPDATE Ua_user SET cPassword = '' WHERE cUser_Id = '171';
select * from Ua_user;
/修改用户表/

/修改用户角色表/
UPDATE UA_Role SET cUser_Id = '171' WHERE cUser_Id = '170';
select * from UA_Role;
/修改用户角色表/

/修改日志表/
UPDATE dbo.UA_Log SET cUser_Id = '171' WHERE cUser_Id = '170';
UPDATE dbo.UA_Log SET cAcc_Id = '171' WHERE cAcc_Id = '170';
select * from dbo.UA_Log;
/修改日志表/

/修改帐套名称/
update UA_Account set cAcc_Id='171' where cAcc_Id='170';
update UA_Account set cAcc_Name='段越的供应链' where cAcc_Name='乔宇鹏的供应链';
update UA_Account set cAcc_Master='171' where cAcc_Master='170';
update UA_Account set cUnitLP='段越' where cUnitLP='乔宇鹏';
select * from ua_account;
/修改帐套名称/
/以上为UFSystem修改内容/