title: Get alias column name of procedure in SQL
body: <p><code>I</code> am using system procedure as follow to get <code>Column Name</code> from procedure.</p>
  
  <pre><code>exec Sp_depends @procedure-name
  </code></pre>
  
  <p>but it is not returning alias column name.</p>
  
  <p>I have following query in procedure.</p>
  
  <pre><code>SELECT ID, E_No As E_No, Case When E_SAL BETWEEN 10000 AND 50000 THEN 1 ELSE 0 END E_ACTIVE
  FROM E_MAST
  WHERE E_SAL BETWEEN 10000 AND 50000"
  </code></pre>
  
  <p>I need all column , including alias column but i cannot return alias. 
  How can i return alias column name from procedure?</p>
  
  <p>current result is :</p>
  
  <pre><code>**name         type   updated selected  column**
  dbo.E_MAST  user table  no      yes       ID
  dbo.E_MAST  user table  no      yes       E_NO
  dbo.E_MAST  user table  no      yes       E_SAL
  </code></pre>
  
  <p>i need this result  :</p>
  
  <pre><code>**name         type   updated selected  column**
  dbo.E_MAST  user table  no      yes       ID
  dbo.E_MAST  user table  no      yes       E_NO
  dbo.E_MAST  user table  no      yes       E_SAL
  dbo.E_MAST  user table  no      yes       E_ACTIVE
  </code></pre>