Need an AutoIncrement Field without Primary-Key

Question

0.00/5 (No votes)

See more:

I am working with SQL-server2008.
For my table I need an auto-Increment(int) field.
But it should not be a Primary-key field.
How can I achieve this..Plz provide the steps..

Posted 12-Apr-11 16:34pm

SHAJANCHERIAN

Add a Solution

2 solutions

Solution 1

There is no way to get it unless you have another Identity field and the required non identity field is derived from it. Why do you want to make it a non identity in the first place?

Posted 12-Apr-11 16:41pm

Pong D. Panda

Comments

SHAJANCHERIAN 12-Apr-11 23:59pm

My table fields are as follows.
//-----------------------------
item_id (This should be an int-AutoIncrement. How can I achive this)
Item_Name(primary-Key)
Item_Brand(primary-Key)
Item_ModelNo(primary-Key)

Pong D. Panda 13-Apr-11 0:17am

What you can do is create an Identity column named item_id with autoincrement as your PK and the other 3 column can be declared as cluster index instead.

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)

Wendelius · Accepted Answer · 2011-04-12T18:31:00

For example when creating the table with T-SQL use the IDENTITY keyword for the proper column. Something like:

SQL

CREATE TABLE MyTable (
   Col1 INT NOT NULL PRIMARY KEY,
   Col2 VARCHAR(100),
   Col3 BIGINT IDENTITY(1,1)
)

For more details, see: CREATE TABLE[^]

[Addition]
Just saw you other post and based on that I got the impression you're using a primary key with several other columns and this identity on alongside it. I would suggest to do it vice versa. Use this identity field as your primary key (both in the database and in the application) and have a unique key on the other columns.