数据库表扩展字段长度

Cc_Rain0624

于 2021-01-11 15:28:16 发布

阅读量3.2k

点赞数 1

分类专栏： ERP-NC

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

版权

ERP-NC 专栏收录该内容

120 篇文章 47 订阅

订阅专栏

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;