ALTER TABLE itm_mst 
ALTER COLUMN itm_mst_partno VARCHAR(100)
GO

ALTER TABLE itm_loc 
ALTER COLUMN itm_loc_part_no VARCHAR(100)
GO

ALTER TABLE mfg_itm 
ALTER COLUMN mfg_itm_partno VARCHAR(100)
GO

ALTER TABLE itm_trx 
ALTER COLUMN itm_trx_partno VARCHAR(100)
GO

ALTER TABLE itm_mtr 
ALTER COLUMN itm_mtr_partno VARCHAR(100)
GO

-- Supplier Part No

ALTER TABLE itm_sup
ALTER COLUMN itm_sup_supplier_partno VARCHAR(100)
GO

ALTER TABLE itm_sup
ALTER COLUMN itm_sup_mfg_partno VARCHAR(100)
GO

ALTER TABLE itm_loc
ALTER COLUMN itm_loc_supplier_partno VARCHAR(100)
GO

ALTER TABLE mtr_ls1
ALTER COLUMN mtr_ls1_supplier_partno VARCHAR(100)
GO

ALTER TABLE puo_ls1
ALTER COLUMN puo_ls1_supplier_partno VARCHAR(100)
GO

ALTER TABLE con_ls1
ALTER COLUMN con_ls1_supplier_partno VARCHAR(100)
GO

-- Itm_Sub Table -- Part No

ALTER TABLE itm_sub
ALTER COLUMN itm_sub_part_no VARCHAR(100)
GO