:::: MENU ::::

Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once.

  • Dec 12 / 2008
  • 0
Data Modeling and Database Design, dbDigger, T-SQL Scripts

Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once.

The error message
Msg 2705, Level 16, State 3, Line 1
Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once.

is run time error message of severity level 16. This error message appears when you try to specify a name for a column more than once upon creation of a table. To execute the statement columns names within a table must be unique.
You may add any check through if exists. In that case you can query following meta data to check existence of any column in a table.

select * from INFORMATION_SCHEMA.COLUMNS
where table_name = 'tableName'
and column_name = 'columnName'
GO
Consult us to explore the Databases. Contact us