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 ERROR:

<>

Msg 2705, Level 16, State 4, Line 5

Column names in each table must be unique. Column name 'CUSTOMER_ID' in table '[DBO].CUSTOMER' is specified more than once.

</>

BUT HERE I WANT "Query executed successfully" is it possible to do this???

please help!!!! thanks in advance....