how to give unique values to primary key column in an sql table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

I am new to sql server and i have created a table named tour package with columns as shown below
id
heading
description
image

Here id is a primary key column and it has to be unique.Here i was unable to make the primary column identity column so that column will have unique id automatically as new records are added.Can anyone tell me how to insert unique values onto primary key column or tell me how to make primary key column identity column using sql query.Please help me.God bless you.Thank you in advance

Posted 3-Aug-14 21:33pm

faizel s

Add a Solution

3 solutions

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)

_Amy · Answer 1 · 2014-08-03T21:37:00

Solution 1

I don't know what is the problem with setting the IDENTITY to your table. But alternatively, you can try inserting MAX(ID) + 1 in ID Column of your table. That'll be unique.

--Amy

Posted 3-Aug-14 21:37pm

_Amy

Comments

faizel s 4-Aug-14 3:59am

Thanks for trying to help me.i am unable to make primary key column identity column.Can u tell me how to make primary column identity column using sql query

_Amy 4-Aug-14 4:46am

You'll have to drop the existing table(before dropping keep backup of data) then create the table with required structure. :)

CPallini · Answer 2 · 2014-08-03T22:05:00

Solution 2

You should be able to create a table with auto increment primary key, see, for instance: "Understanding Auto Increment in SQL Server"[^].

Posted 3-Aug-14 22:05pm

CPallini

Peter Leow · Answer 3 · 2014-08-03T22:06:00

Solution 3

Check this out:
how-to-alter-column-to-identity[^]

Posted 3-Aug-14 22:06pm

Peter Leow