【结帖】清空组织机构数据问题**

alang

另外，回收站中的组织单元也应该清掉吧
--清空组织机构回收站
DELETE FROM TOrgAttribute WHERE FGUID IN (SELECT FGUID FROM TOrgSystem WHERE FDeleteLevel >0);
DELETE FROM TOrgIndex WHERE FGUID IN (SELECT FGUID FROM TOrgSystem WHERE FDeleteLevel >0);
DELETE FROM TOrgContent WHERE FGUID IN (SELECT FGUID FROM TOrgSystem WHERE FDeleteLevel >0);
DELETE FROM TOrgSystem WHERE FDELETELEVEL>0

cdz0451

alang  能给一个完整删除 的SQL吗？

shangxy

2楼加10楼11楼就是一个完整的了

zfang

揭帖