when m running this query <>go

IF NOT EXISTS (SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = '[DBO].CUSTOMER'

AND COLUMN_NAME = 'CUSTOMER_ID')

ALTER TABLE [DBO].CUSTOMER ADD CUSTOMER_ID int NULL

go

</>

AND ITS GIVING...