Hi All,
How to add a candidate key in a table in SQl??
Please Help.
Thanks.
Piya27
4
Junior Poster
Recommended Answers
Jump to PostPriya,
Read this : http://databases.about.com/cs/specificproducts/g/candidate.htm
Jump to Postset Primary key.
All 5 Replies
babbu
-12
Posting Whiz in Training
m not really sure but i think candidate key is the column which qualifies to be a primary key.
so u can set this column as primary key if u wish to at a later date.
but i dont think you can assign a candidate key
kvprajapati
1,826
Posting Genius
Team Colleague
Piya27
4
Junior Poster
What I actually want is to make one key of my table as candidate key.
I used keyword UNIQUE also but I was not able to accomplish the task.
Pls suggest.
kvprajapati
1,826
Posting Genius
Team Colleague
set Primary key.
Piya27
4
Junior Poster
set Primary key.
But Sir, I don't want to set the key as primary key..
Actually, I am sorry not to tell my problem in detail..
Specifically, I have a table with enrolno as primary key and I want to make classid As Candidate key, because I want to reference ClassID from a foreign key of another table. For that when I use the query to set FOREIGN KEY constraint that refers to the classid of this table,i get the error asking for classid to be either primary or candidate key..
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.