SQL中删除单据

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

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...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息