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:
- Specified scale is invalid
- Foreign key references invalid column in referenced table
- Table already has a primary key defined on it
- Column name does not exist in the target table or view
- Violation of PRIMARY KEY constraint
- There is already an object named in the database
- Could not find stored procedure
