title: List schema name and owners in sql server 2012
body: <p>I wanted to list all the table names, column names , schema names and owner in all databases and wrote the code below . I am not sure where to get the schema owners details to add to my query . Please help .</p>
  
  <pre><code>select  c.name as colomn_name , t.name as table_name , s.name as schema_name 
   from sys.columns c 
     inner join  sys.tables t     on c.object_id=t.object_id
     INNER JOIN sys.schemas AS s  ON t.[schema_id] = s.[schema_id]
  </code></pre>