Msg 2705 Level 16 - Column names in each table must be unique

Transact sql error message Msg 2705 Level 16 - Column names in each table must be unique - means that the column is already defined in the table.


Msg 2705 Level 16 Example:

USE model;
GO
ALTER TABLE students ADD dep_id INT;
GO

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

Other error messages: