title: Compare indexes in two databases
body: <p>When updating our clients' software and databases, we're comparing their database to our development database, to be sure that no tables are missing and that all tables look the same.</p>
  
  <p>It's an easy job doing this because of the information stored in <code>[DB].Information_Schema.Columns</code>.</p>
  
  <p>Now, we want to compare all the indexes in the client database to our development database, but I have no idea where to look to do a comparison. So, where do I start looking?</p>
  
  <p>&#160;</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>I would love a TSQL solution rather than getting more software to do the job. And yes, I know that RedGate has some great solutions, but I'm not willing to pay for something I can do for free. This question is not only to get the job done, but to get even more knowledge about SQL Server and learning.</p>