title: Selecting default value SQL management studio
body: <p>I have SQL Server and I am using SQL management studio. What I want is to select default value of column of multiple tables in database.
  For example I have database DB. In DB I have 3 tables - tableA, tableB and tableC.
  All of them have the same columns. What I want is to get default values of columns 'Customers' for tables A,B and C.</p>
  
  <p>It must be something like this:</p>
  
  <pre><code>SELECT Column_Default 
  FROM Information_Schema.Columns
   WHERE Table_Schema = DB AND 
   Table_Name like 'table%' and
   Column_Name = 'Customers'
  </code></pre>
  
  <p>But there is error in Table_Schema = DB. I am not sure it should look like this as SQL syntax. It is working as MySQL but not here.</p>