title: t-sql Table columns to String
body: <p>Is it possible to string a table columns headers dynamically from information_schema recursively  </p>
  
  <p>So if I had 2 tables (or however many) in my database with 5 columns each </p>
  
  <p>Could I get the query to find this tables by schema and then string all the table columns hearders into another table ending up with something like </p>
  
  <pre><code>table name ¦ string 
  Table A    ¦ id,columnName1,columnName2 ,columnName3 ,columnName4 ,columnName5
  Table b    ¦ id,columnName1,columnName2 ,columnName3 ,columnName4 ,columnName5
  </code></pre>
  
  <p>(THESE ARE TWO ROWS BTW)</p>