ALTER TABLE SLCShipmentPackage
ALTER COLUMN UCCId VARCHAR(50) NULL;
Go

Alter Table [dbo].[SLCShipmentPackageContent]
    Alter Column [SLCShipmentInformation_Id] bigint NULL
Go

Alter Table [dbo].[SLCShipmentPackageContent]
    Alter Column SLCShipmentDetail_Id bigint NULL
Go

Alter Table [dbo].[SLCShipmentPackageContent]
    add LotArray varchar(2000),
    SerialNumberArray varchar(2000)
Go