A primary key is one that uniquely identifies a record . Also there are cases when primary key of one file appears in another file. In that case the key is called Foreign key.
foreign key
Index key
key
Primary Sort Key
No. The foreign key is always on the many side. A foreign key is a field that is a primary key in another table, not in the table it is in. It can therefore be repeated in the table it is, so it can act as the many side. In its own table, it is the primary key, and only appears once.
Also called a Key field.
Primary Sort key
It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS
primary key
Foreign Key
when a primary key from one table is stored as an attribute of another table
A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.
A Foreign Key.