if exists (SELECT 1 FROM sys.indexes WHERE name='TMteUntCode2' AND object_id = OBJECT_ID('VS4TJobProdMat'))
	DROP INDEX TMteUntCode2 ON VS4TJobProdMat
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TMteUntCode1' AND object_id = OBJECT_ID('VS4TJobProdMat'))
	DROP INDEX TMteUntCode1 ON VS4TJobProdMat
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TMteUntCode' AND object_id = OBJECT_ID('VS4TJobProdMat'))
	DROP INDEX TMteUntCode ON VS4TJobProdMat
GO
ALTER TABLE VS4TJobProdMat
	DROP COLUMN TMteProductName, TMteCustom1, TMteCustom2, TMteCustom3, TMteCustom4, TMteCustom5, TMteUntCode, TMteUntCode2, TMteUntCode3
GO
