title: SQL Query to search schema of all tables
body: <p>I am working on a SQL Server 2008 Db that has many tables in it (around 200). Many of these tables contain a field by the name "CreatedDate". I am trying to identify all the table schema with this particular field.</p>
  
  <p>Is there a SQL query to do this?</p>