Question

differentiat between foreign and primary key

Answer 1

primary key is the combination of column of a table that uniquely identify a row of the table while foreign key is the field of a table that matches the key of a priamry table..

Answer 2

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