Remove the [DBO] from the WHERE table_name = '[DBO].CUSTOMER'

Your IF NOT EXISTS should look like:

IF NOT EXISTS (SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'CUSTOMER'

AND COLUMN_NAME = 'CUSTOMER_ID')

ALTER TABLE [DBO].CUSTOMER ADD CUSTOMER_ID int NULL