if exists (SELECT 1 FROM sys.indexes WHERE name='TJMSTUntCode3' AND object_id = OBJECT_ID('VS4TJobMBSerial'))
	DROP INDEX TJMSTUntCode3 ON VS4TJobMBSerial
GO
if exists (SELECT 1 FROM sys.indexes WHERE name='TJMSTUntCode2' AND object_id = OBJECT_ID('VS4TJobMBSerial'))
	DROP INDEX TJMSTUntCode2 ON VS4TJobMBSerial
GO
ALTER TABLE VS4TJobMBSerial
	DROP COLUMN TJMSSerialName, TJMSCaseNo, TJMSTUntCode2, TJMSTUntCode3, TJMSShape, TJMSSize, TJMSQuality, TJMSCustomText1, TJMSCustomText2, TJMSCustomText3, TJMSCustomText4, TJMSCustomText5, TJMSCustomText6, TJMSCustomText7, TJMSCustomText8, TJMSCustomText9, TJMSCustomText10, TJMSCustomValue1, TJMSCustomValue2, TJMSCustomValue3, TJMSCustomValue4, TJMSCustomValue5, TJMSCustomValue6, TJMSCustomValue7, TJMSCustomValue8, TJMSCustomValue9, TJMSCustomValue10
GO
