How do I create an Alternate Key in SQL?

How do I add an alternate key?

Each alternate key can generate a unique index or a unique constraint in a target database.1Open the property sheet of a table and select the Columns tab.2Select the column or columns to associate with the alternate key and click the Create Key tool. ... 3Enter a name for the key.Creating Alternate Keys - Sybase InfoCenter

How do you define alternate key in SQL?

If a table has more than one candidate key, one of them will become the primary key and rest of all are called alternate keys. In simple words, you can say that any of the candidate key which is not part of primary key is called an alternate key.

What is alternate key in SQL with example?

A candidate key not selected as a primary key is called alternate or secondary key. Candidate key is an attribute or set of attributes that you can consider as a Primary key. Let us see an example − Student_ID. Student_Enroll.

What is alternate key example?

All the keys which are not primary key are called an Alternate Key. Example: In this table, StudID, Roll No, Email are qualified to become a primary key. But since StudID is the primary key, Roll No, Email becomes the alternative key.