title: hide a column from table in MS SQL Server
body: <p>Can anyone please share the steps to hide the particular column from the table in SQL Server 2012 as I don't want to delete that column</p>
  
  <p>By hide I mean that whenever I use the select query against that particular table it should never show me that column.</p>
  
  <p>Is it possible?
  I need to make the column as hidden irrespective of any user login and whatever query i use</p>
  
  <h3>3rd party edit</h3>
  
  <p>Based on the comment <code>But the problem is whenever i open the table in sql i dont want to see that particular column</code> i assume that the question is: </p>
  
  <ul>
  <li>How can i configure <a href="/questions/tagged/ssms" class="post-tag" title="show questions tagged &#39;ssms&#39;" rel="tag">ssms</a> so that opening a table definition inside sql management studio to only show the columns the connected user has select right to?</li>
  </ul>
  
  <p>The screenshot below shows all columns of the table Employee despite the fact that the login <code>StackoverIntern</code> has no select rights to the columns <code>SSN, Salary</code></p>
  
  <p><a href="https://i.stack.imgur.com/f8edM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/f8edM.png" alt="SSMS table defintion shows all columns"></a> </p>