View previous topic :: View next topic
|
Author |
Message |
edwin
New User
Joined: 27 Apr 2005 Posts: 4
|
|
|
|
Hi friends,
Is there any possibility of having more than one primary key in a single table. |
|
Back to top |
|
|
vijayamadhuri
Active User
Joined: 06 Apr 2005 Posts: 180
|
|
|
|
It is not possible to have have more than one primary key for the table as the PRIMARY KEY defined for the table is UNIQUE and the uniqueness of the table is retained by the PRIMARY KEY. |
|
Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003 Posts: 568 Location: Bangalore
|
|
|
|
Dear Edwin, Do you mean Partial Keys? |
|
Back to top |
|
|
kanak
Moderator
Joined: 12 Mar 2005 Posts: 252 Location: India
|
|
|
|
no more than one primary key is not possible...ya but composite keys are possible where two or more than two field can create a unique value. |
|
Back to top |
|
|
|