title: Why does sp_columns return no results?
body: <p>I'm trying to "describe" a table for a different post I have on StackOverflow, but when I run sp_columns, no results or rows are shown.</p>
  
  <pre><code>sp_columns assignee
  </code></pre>
  
  <p>Results:</p>
  
  <pre><code>A bunch of column headers...
  </code></pre>
  
  <p>What's wrong with my database, and why doesn't this work? </p>