What is the key ?
- A key is a value that is used to identify a record uniquely in a table .
- Keys can be defined on single or multiple columns depending on the requirement.
- Columns that are used to define a key is known as key column
- Similarly, columns that are not used to define a key are called non-key columns.