SQL中删除单据
### 问题描述:正常删除单据操作如下图所示,但是某些未知原因的场景下,元数据无法正常删除,需
手动处理。
![16488031131.webp](/download/0100cd8677c9918b406a8160a9248e83c45e.webp)
### 解决方案:
假定要删除的元数据的标识为【TB_TestBill】,数据库执行以下SQL直接删除。
-- 元数据主数据
DELETE FROM T_META_OBJECTTYPE WHERE FID='TB_TestBill'
DELETE FROM T_META_OBJECTTYPE_L WHERE FID='TB_TestBill'
DELETE FROM T_META_OBJECTTYPE_E WHERE FID='TB_TestBill'
DELETE FROM T_META_OBJECTTYPENAMEEX WHERE FID='TB_TestBill'
DELETE FROM T_META_OBJECTTYPENAMEEX_L WHERE FENTRYID='TB_TestBill'
DELETE FROM T_META_OBJECTTYPEVIEW_L WHERE FID IN (SELECT FID FROM
T_META_OBJECTTYPEVIEW WHERE FDEPENDENCYOBJECTID='TB_TestBill')
DELETE FROM T_META_OBJECTTYPEVIEW WHERE FDEPENDENCYOBJECTID='TB_TestBill'
DELETE FROM T_META_OBJECTTYPECACHE WHERE FID='TB_TestBill'
SQL中删除单据
### 问题描述:正常删除单据操作如下图所示,但是某些未知原因的场景下,元数据无法正常删除,需手动处理。![16488031131.webp](/download...
点击下载文档
上一篇:BOM多级展开查询下一篇:恢复账套后不知道登录密码操作步骤
本文2024-09-16 17:18:28发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14861.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章