if exists (SELECT 1 FROM sys.indexes WHERE name='TPmTUnitCode2' AND object_id = OBJECT_ID('VS4TJobMaterial'))
	DROP INDEX TPmTUnitCode2 ON VS4TJobMaterial
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TPmTUnitCode1' AND object_id = OBJECT_ID('VS4TJobMaterial'))
	DROP INDEX TPmTUnitCode1 ON VS4TJobMaterial
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TPmTUnitCode' AND object_id = OBJECT_ID('VS4TJobMaterial'))
	DROP INDEX TPmTUnitCode ON VS4TJobMaterial
GO
ALTER TABLE dbo.VS4TJobMaterial
	DROP COLUMN TJMtProductName, TJMtCustom1, TJMtCustom2, TJMtCustom3, TJMtCustom4, TJMtCustom5, TJMtUnitCode, TJMtUnitCode2, TJMtUnitCode3
GO
