Saturday 11 May 2019

MSSQL - Fix Error Column names in each table must be unique. Column name 'col1' in table 'TableTest' is specified more than once.

Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'col1' in table 'TableTest' is specified more than once.


Watch this example on YouTube

to fix it replcae

ALTER TABLE TableTest
Add col1 int
Go

with

ALTER TABLE TableTest
Add col1UNIQUE int
Go

No comments:

Post a Comment