Please Explain What is Alternate key and Different B/W Primary Index and Cluster INdex
A table can have several alternate keys. Any one alternate key can switch to being the primary key, if the alternate key is comprised of only one field.
Primary Index should be unique and contains single field, which has alternated key property set to yes.
Cluster index no need to unique, used for fetching.
msdn.microsoft.com/…/hh812105.aspx
It’s good to use documentation, otherwise you may misguided. Use documentation and practice, if have queries post here.