creating pimary key in a database table

Question

0.00/5 (No votes)

See more:

I have crated ID as primary key

For an example
ID-4111
name- customer
ledger-1
ename-SHAKEER

but for 2nd time
ID-4111
name-supplier
ledger-2
ename-shakeer

can i create like this

Posted 30-Dec-13 1:10am

shakeer mp

Add a Solution

Comments

TrushnaK 30-Dec-13 7:18am

what you want to do exactly.

4 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)

Peter Leow · Answer 1 · 2013-12-30T01:27:00

No. The ID cannot have duplicate value, that means there cannot be more than one ID with the same value of 4111 in that table. The column that is designated as primary key in a table can only contain unique values. The purpose of primary key is to ensure that there is no duplicate records in a table. Learn more about relational database from this quick guide Relational_Database_Design.html[^]

thatraja · Answer 2 · 2013-12-30T01:28:00

Solution 2

You're looking for Composite Primary Keys[^]

Posted 30-Dec-13 1:28am

thatraja

LENINRAJ RAJENDRAN · Answer 3 · 2013-12-30T01:28:00

Solution 3

Hi ,

Primary key is Unique one. u can't create like that

Posted 30-Dec-13 1:28am

LENINRAJ RAJENDRAN

TrushnaK · Answer 4 · 2013-12-30T01:34:00

Solution 4

primary key is unique key. it can't duplicate value.
as per your senario you have to use primary keys[^]

Posted 30-Dec-13 1:34am

TrushnaK