IF (NOT EXISTS 
	(SELECT * FROM INFORMATION_SCHEMA.COLUMNS  
    WHERE TABLE_NAME = 'pal_Attachment' AND COLUMN_NAME = 'fileMetadata'
    AND DATA_TYPE = 'NVARCHAR'))
BEGIN
	ALTER TABLE pal_Attachment
        ADD fileMetadata NVARCHAR(MAX) NULL
END