更新表字段长度属性

1、根据类全名定位对应类型ID

select Local_ID,FullName from ubf_md_class where FullName like '命名空间'
ubf_md_class

2、根据类型ID定位对应数据表字段属性

select Local_ID,Local_Class_ID,Name,Length from UBF_MD_Attribute where Local_Class_ID =1001908020010001
UBF_MD_Attribute

3、更新对应数据表字段类型长度

update UBF_MD_Attribute set Length =9999 where Local_Class_ID =1001908020010001 and Local_ID=1001908020010021  --Local_Class_ID 类型ID,Local_ID 属性ID
UBF_MD_Attribute

注释:该脚本适用于测试环境,正式环境慎用。

原文地址:https://www.cnblogs.com/youmin3205/p/11330949.html