数据库表扩展字段长度

最新推荐文章于 2024-07-28 03:29:17 发布

Cc_Rain0624

最新推荐文章于 2024-07-28 03:29:17 发布

阅读量3.1k

点赞数 1

分类专栏： ERP-NC

本文链接：https://blog.csdn.net/Cc_Rain0624/article/details/112471289

版权

ERP-NC 专栏收录该内容

118 篇文章 46 订阅

订阅专栏

Alter Table Ct_Pu Modify Custunit Varchar(300); 
alter table ct_sale modify custunit varchar(300);
Update Md_Property Set Attrlength = 300 Where Classid In (Select Id From Md_Class Where Name In ('ct_pu','ct_sale')) And Name In ('custunit'); 
update md_column set columnlength = 300 where tableid in ('ct_pu','ct_sale') and name in ('custunit');
commit;