title: MS-Access - how to find the name of the composite primary key and associated fields
body: <p>I have a bunch of Access databases, each of which has several tables. Each table has a composite primary key, with varying fields comprising that key.</p>
  
  <p>How can I, for a given table, get the name of the primary key and the names of the fields which are used in it? I.e., what's the SQL to do that? (I need to use raw SQL rather than Visual Basic)</p>
  
  <p>BTW I know that I can open the tables in the Access GUI and see the primary keys there but I need to automate the process so that I can modify the primary keys.</p>
  
  <p>thanks!
  max</p>