Question: what is the difference between primary key unique key and foreign key?
Answer: Unique key can accept only one null value. By default, Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index. ... Primary key can be made foreign key into another table. In SQL Server, Unique key can be made foreign key into another table.