ALTER TABLE VS4TInventoryLOTQC
	DROP CONSTRAINT PK_VS4TInventoryLOTQC
GO
ALTER TABLE VS4TInventoryLOTQC ADD
	TLQCTQCDNo nvarchar(30) NOT NULL
GO
ALTER TABLE VS4TInventoryLOTQC
	DROP COLUMN TLQCLn, TLQCTQCCCode, TLQCName, TLQCSpecification, TLQCCondition, TLQCMethod, TLQCValue, TLQCResult, TLQCNote
GO
EXECUTE sp_rename N'VS4TInventoryLOTQC.TLQCTIMCTPdtCode', N'TLQCTPdtCode', 'COLUMN'
GO
ALTER TABLE VS4TInventoryLOTQC ADD CONSTRAINT
	PK_VS4TInventoryLOTQC PRIMARY KEY CLUSTERED 
	(
	TLQCTPdtCode,
	TLQCCustom1,
	TLQCSerialNo,
	TLQCLotNo,
	TLQCLotDate,
	TLQCTQCDNo
	)  ON [PRIMARY]
GO