title: getting correct schema name
body: <p>I am using this query to get the schema name too </p>
  
  <pre><code>SELECT sysusers.name AS OwnerName,* FROM sysobjects 
              INNER JOIN sysusers ON sysobjects.uid = sysusers.uid 
              WHERE xtype= 'U'
  </code></pre>
  
  <p>but it is returning me wrong schema name, i know the schema comes from <code>sys.schema</code> but not entirely sure how can i get without duplicating the rows </p>