title: SSMS: How to find columns with similar names, but different data types
body: <p>How to find columns with similar names, but different data types within the predefined scope of tables?</p>
  <p>The Goal: <strong>to verify columns metadata within a project</strong>.</p>
  <p>For example: column <code>deal_id</code> is used in 3 tables.</p>
  <p>I want to be sure that deal_id metadata is everywhere the same.</p>
  <p>To avoid following:</p>
  <ul>
  <li>table<strong>1</strong>.deal_id is <strong>n</strong>varchar(50)</li>
  <li>table<strong>2</strong>.deal_id is  varchar(50)</li>
  <li>table<strong>3</strong>.deal_id is <strong>n</strong>varchar(<strong>6</strong>0)</li>
  </ul>