if exists (SELECT 1 FROM sys.indexes WHERE name='TPmTUnitCode2' AND object_id = OBJECT_ID('VS4TProductMat'))
	DROP INDEX TPmTUnitCode2 ON VS4TProductMat
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TPmTUnitCode1' AND object_id = OBJECT_ID('VS4TProductMat'))
	DROP INDEX TPmTUnitCode1 ON VS4TProductMat
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TPmTUnitCode' AND object_id = OBJECT_ID('VS4TProductMat'))
	DROP INDEX TPmTUnitCode ON VS4TProductMat
GO
ALTER TABLE VS4TProductMat
	DROP COLUMN TPMtProductName, TPMtUnitCode, TPMtUnitCode2, TPMtUnitCode3, TPMtCustom1, TPMtCustom2, TPMtCustom3, TPMtCustom4, TPMtCustom5
GO
