title: Get XML schema used by sql column
body: <p>I want to select xml schema assigned to a xml column in my SQL Server database, from a SQL statement.</p>
  
  <p>I am stuck, I've looked in <code>information_schema.columns</code> with no luck, I can just alter it.</p>
  
  <p>In Management Studio, in column properties under <code>Xml Type Specification</code> I can set (scheme collection) I want to simply select this from SQL statement.</p>
  
  <p>Thanks for your help.</p>