USE [HelpDesk01_Dat]
GO

/****** COMMUNICATION RECEIVED ******/

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE  TABLE_NAME = 'tblDts' AND COLUMN_NAME = 'Communication_Received' )
	ALTER TABLE [dbo].[tblDts] ADD [Communication_Received] [int] NULL;
GO

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE  TABLE_NAME = 'tblDts' AND COLUMN_NAME = 'Subcategory' )
	ALTER TABLE [dbo].[tblDts] ADD [Subcategory] [int] NULL;

GO

	











