自定义字段操作

删除自定义字段

delete UBF_MD_Attribute where Local_ID = 1002506250430001
delete UBF_MD_Attribute_Trl where Local_ID = 1002506250430001
delete UBF_RES_ResourceValue where ResourceID = '3CBCBD81-56F6-4030-8D9C-40BDC562B791' AND LanguageName = 'zh-CN'
-- 修复删除字段后报错问题
EXEC p_CreateCustomType 'CBO_ItemMaster' 
exec p_ReBuildTableByMetedata 'CBO_ItemMaster'

修改字段名称

-- 查询字段
select top 1 * from UBF_RES_ResourceValue where ResourceName = '358FA4DF-D41D-4415-B926-C5ABD6C3432F'
-- 修改名称
update UBF_MD_Attribute_Trl set DisplayName = '钢号（下）' where Local_ID = 1002506250430001
update UBF_RES_ResourceValue set DisplayName = '钢号（下）' where ResourceID = '3CBCBD81-56F6-4030-8D9C-40BDC562B791'