IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvoiceICV' AND COLUMN_NAME = 'ReUploaded' ) BEGIN ALTER TABLE InvoiceICV ADD ReUploaded BIT CONSTRAINT DF_InvoiceICV_ReUploaded DEFAULT 0; END