Column Names in each table must me unique - making a column identity

Question

1.00/5 (2 votes)

See more:

SQL-Server-2012

Hello, for some reason when I try to make a column an identity it gives me the error that column names must be unique. I know what this is supposed to mean, but the problem is that I don't have duplicate columns. Also, I tried to make other columns the identity just to test it out and it doesn't work on any column in my table. Has anyone ever ran into this problem?

Posted 3-Mar-15 7:23am

britbarnes

Add a Solution

Comments

Kornfeld Eliyahu Peter 3-Mar-15 13:34pm

You may already have an identity column?

Sergey Alexandrovich Kryukov 3-Mar-15 14:04pm

How are we supposed to be sure that your column names are unique in the scope of the table? The facts, as you present them, tell us the opposite.
—SA

britbarnes 3-Mar-15 14:09pm

How can I show you that they are unique in the scope of the table?

Sergey Alexandrovich Kryukov 3-Mar-15 14:19pm

This is up to you how you do it. I shared my though on that, you can use it. Just check up things properly.
—SA

britbarnes 3-Mar-15 14:21pm

When I used select * from table, there were no duplicate columns. Is there another method I should use to check for duplicates that maybe I can't see?

Sergey Alexandrovich Kryukov 3-Mar-15 14:37pm

I have no idea. Maybe your observation are invalid; maybe the column names were not unique at some moment of time or something else. Just check everything thoroughly; it doesn't look like a real problem.
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2015-03-03T07:34:00

Solution 1

If you have data in your table then you have to make sure that the data is unique and without duplicates before altering that table, the error is probably referring to that and not the column name.

Posted 3-Mar-15 7:34am

Mehdi Gholam

Updated 3-Mar-15 8:09am

v2

Comments

britbarnes 3-Mar-15 13:46pm

Hello thank you, but I double checked and do not have any duplicate rows in this column

PIEBALDconsult 3-Mar-15 14:02pm

Not rows, column names.

britbarnes 3-Mar-15 14:06pm

I also made sure that there were no duplicate columns in the table. Could they be hidden somewhere?

britbarnes 3-Mar-15 14:27pm

There is no duplicate data in the columns or the rows

Mehdi Gholam 3-Mar-15 14:35pm

Try creating a new table with structure you require and then moving your data into that.

Also since we cannot see what you have done and the error you are getting there is very little we can do other than speculate.

PIEBALDconsult 3-Mar-15 14:42pm

It's not the data.

britbarnes 3-Mar-15 15:04pm

what do you think it is?

Sergey Alexandrovich Kryukov 3-Mar-15 14:06pm

5ed. This answer is not a big deal, but no one cannot blame you for telling the truth (like someone who down-voted this correct answer).
—SA

Mehdi Gholam 3-Mar-15 14:09pm

Cheers Sergey!