Alternate Key

The alternate key is a secondary key.

Let us take an example table

StudentID Student_Name Address City
1 Nithin Bank Street Hyderabad
2 Bharath White Field Bangalore
3 Goutham Court road Chennai


Here Student ID is Primary key and rest of all columns is defined as Alternate keys.

In general Alternate key can be defined as the key which is not a primary key.

Here in the table Student_Name, Address, City are called as Alternate Keys.