Question

difference between primary key and foreign key
​

Answer 1

Primary keyuniquely identify a record in thetable. Foreign key is a field in thetable that is primary key in another table. By default, Primary key is clustered index and data in thedatabase table is physically organized in the sequence of clustered index.