Column names in each table must be unique.

Question

I have an script to update a database. That script create some columns in several tables. Some of that columns and so the message "Column names in each table must be unique." is shown. How can I disable this kind of message when running the script?

Thanks in advance. Rui

Answer 1

It seems your database script is trying to create a column that already exists in your table.

Put in a check into your SQL script to add the column only if it doesn't already exist:

IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = 'ColumnName' 
              AND object_id = OBJECT_ID('YourTableName'))
BEGIN
   ALTER TABLE dbo.YourTableName
      ADD ColumnName INT    -- or whatever it is
END

Marc

Answer 2

If I understand you correctly, you need to fix your database update script: the error is pretty clear, in that your SQL appears to specify updates to (or even creating) a column in a given table more than once.

Check the SQL you're using.