IF NOT EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[CSAPP_RENTAL_TPYES]')
AND name = 'CUSTOMER_PAYMENT_MANDATORY')
ALTER TABLE CSAPP_RENTAL_TPYES ADD CUSTOMER_PAYMENT_MANDATORY BIT  NULL