title: Pros and Cons of autoincrement keys on "every table"
body: <p>We are having a rather long discussion in our company about whether or not to put an autoincrement key on EVERY table in our database.</p>
  
  <p>I can understand putting one on tables that would have a FK reference to, but I kind-of dislike putting such keys on each and every one of our tables, even though the keys would never be used.</p>
  
  <p>Please help with pros and cons for putting autoincrement keys on every table apart from taking extra space and slowing everything a little bit (we have some tables with hundreds of millions of records).</p>
  
  <p>Thanks</p>