更新表字段长度属性
程序员文章站
2022-03-20 22:09:45
1、根据类全名定位对应类型ID select Local_ID,FullName from ubf_md_class where FullName like '命名空间' 2、根据类型ID定位对应数据表字段属性 select Local_ID,Local_Class_ID,Name,Length f ......
1、根据类全名定位对应类型id
select local_id,fullname from ubf_md_class where fullname like '命名空间'
2、根据类型id定位对应数据表字段属性
select local_id,local_class_id,name,length from ubf_md_attribute where local_class_id =1001908020010001
3、更新对应数据表字段类型长度
update ubf_md_attribute set length =9999 where local_class_id =1001908020010001 and local_id=1001908020010021 --local_class_id 类型id,local_id 属性id
说明:该脚本实用与测试环境,正式环境慎用。