AFFINITY_COLUMN & PK column in the TABLE_COLUMNS view are always FALSE.

execute the sql:

CREATE TABLE City (
  ID INT,
  Name VARCHAR,
  CountryCode CHAR(3),
  District VARCHAR,
  Population INT,
  PRIMARY KEY (ID, CountryCode)
);

then select * from sys.table_column where table_name = 'CITY';