热度 1|
新建一套账,把rpt开头的表直接通过编辑复制内容过去,之前的全删除了就行。
这个表 rpt_glbdef
Select Systemid,id,name from rpt_glbdef where relation='heron' and type <>0 and isbasetable=0 Order by SystemID ,ID
Select Systemid,id,name from ufdata_993_2020..rpt_glbdef where relation='heron' and type <>0 and isbasetable=0 Order by SystemID ,ID
select * from ufdata_993_2020..rpt_glbdef
truncate table rpt_glbdef
Select cid , citemname ,cItem from userdef order by cid
Select cid , citemname ,cItem from ufdata_993_2020..userdef order by cid
|站长微信|Archiver|手机版|小黑屋|用友之家 ( 蜀ICP备07505338号|51072502110008 )
GMT+8, 2024-5-9 15:53 , Processed in 0.015037 second(s), 8 queries , Gzip On, Redis On.
Powered by Discuz! X3.5
© 2001-2024 Discuz! Team.