通过SQL语句修改K3系统物料中规格型号、备注字段的字段长度

注意：不建议直接通过数据库修改基础资料的字段长度！

–修改物料中规格型号的字段长度

exec p_AlterColumn ‘t_ICItemCore’,’FModel’,’varchar(255)’

GO

–实际长度

UPDATE t_ItemPropDesc SET FActualSize = 255 WHERE FItemClassID = 4 AND FSQLColumnName =’FModel’

GO

–精度，也是字符串的长度

UPDATE t_ItemPropDesc SET FPrecision = 255 WHERE FItemClassID = 4 AND FSQLColumnName =’FModel’

GO

–修改物料中备注的字段长度

EXEC p_AlterColumn @TableName = ‘t_ICItemMaterial’,@ColumnName = ‘FNote’,@NewType = ‘VARCHAR(255)’

UPDATE t_ItemPropDesc SET FActualSize = 255 WHERE FItemClassID = 4 AND FSQLColumnName =’FNote’

UPDATE t_ItemPropDesc SET FPrecision = 255 WHERE FItemClassID = 4 AND FSQLColumnName =’FNote’

GO