Key classification is heuristic: a column is treated as a primary key when its constraint name starts with PK, otherwise as a foreign key.
SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...