K3Wise清除用户信息

declare @fuserid int
select @fuserid=fuserid from t_user where fname ='XXX' -----根据情况修改
delete b from ICClassFilterProfile a inner join ICClassFilterProfileEntry b on a.fschemeid=b.fschemeid where a.fuserid=@fuserid
delete from ICClassFilterProfile where fuserid=@fuserid
delete b from ICClassProfile a inner join ICClassProfileEntry b on a.fschemeid=b.fschemeid where a.fuserid=@fuserid
delete from ICClassProfile where fuserid=@fuserid
delete from ICClassUserProfile where fuserid=@fuserid
delete from ICReportProfile where fuserid=@fuserid
delete b from ICSchemeProfile a inner join ICSchemeProfileEntry b on a.fschemeid=b.fschemeid where a.fuserid=@fuserid
delete from ICSchemeProfile where fuserid=@fuserid
delete from t_UserProfile where fuserid =@fuserid

 

posted @ 2020-07-15 15:14  allen1991  阅读(525)  评论(0)  编辑  收藏  举报