Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: ADD A COLUMN TO A TABLE IN T-SQL

    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...

Viewing post 1 (of 1 total)