pyodbc-从MS Access（MDB）数据库读取主键

对于Access ODBC，我们可以通过

.statistics

cursor

crsr = conn.cursor()table_name = 'MyTable'# dict comprehension: {ordinal_position: col_name}pk_cols = {row[7]: row[8] for row in crsr.statistics(table_name) if row[5]=='PrimaryKey'}print(pk_cols)  # e.g., {1: 'InvID', 2: 'LineItem'}