Question

explain primary key, candidate key, Alternate key and foreign key using example.​

Answer 1

Answer:

Primary keys are used to identify tables. There is only one primary key per table. In SQL Server when we create primary key to any table then a clustered index is automatically created to that column. Foreign key are those keys which is used to define relationship between two tables.