What is alternate key in sql server and how to write query

Posted by Jitendrasoft09 under Sql Server on 6/26/2013 | Points: 10 | Views : 1653 | Status : [Member] [MVP] | Replies : 2
Hi All,
I want to understand What is alternate key in sql server and how to write query , let me know if anybody knows.

Jitendra Kumar
If my post helps you, plz mark as an answer.



Responses

Posted by: Satyapriyanayak on: 6/26/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
http://www.dotnet-tricks.com/Tutorial/sqlserver/GcF9120312-Different-Types-of-SQL-Keys.html

If this post helps you mark it as answer
Thanks

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeraaj.Sharma on: 7/5/2013 [Member] Starter | Points: 25

Up
0
Down
mark as Ans if if get the ANS

You can`t create a alternate key as its a term used in databases,
When you design table and look for columns those can be primary key ,
any chose one leave rest of columns those keys (column you left out called Alternate keys,

Example you have table :
ID PhoneNO name

ID can be a primary key or phoneno as well, cause both identify row uniquely,
if you choose id as primary key then phoneno is your alternate key.

i hope you get that


Visit my blog
www.tutorialsqlserver.com




Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response