Home » SQL & PL/SQL » SQL & PL/SQL » Alternate keys
Alternate keys [message #8776] Thu, 25 September 2003 04:12 Go to next message
ashish upadhyay
Messages: 1
Registered: September 2003
Junior Member
Can u explain me what we mean by alternate keys?

Report message to a moderator

Re: Alternate keys [message #8784 is a reply to message #8776] Thu, 25 September 2003 07:28 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Any candidate key(unique column or compound unique col) that is not the primary key is considered an alternate key.

For eg)
Create table t(x int primary key,y int unique)

Here y is the alternate key.

Thiru

Report message to a moderator

Previous Topic: Accent question
Next Topic: droping tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 18:10:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.