In the school example, the primary key used to identify each member of staff in the teacher table is Staff ID. A foreign key is a primary key from one table that appears in another table to link ...

(Could be a duplication of SKU above.) ProductName [nvarchar](60) Text(60) Product Name ProductDescription [nvarchar](255) Text(255) Product Description - could be an ntext field in SQL 7 or memo ...