title: SQL Server intellisense for columns not working for some tables in SQL Server 2008 R2
body: <p>I am having some troubles with intellisense in SQL Server 2008 R2.</p>
  
  <p>Intellisense for all tables works fine, but the column intellisense only seems to work for some tables.</p>
  
  <p>For example, this query pulls up a list of all the functions and navigates to the items starting with "sta":</p>
  
  <pre><code>select *
  from tbl_cash_stats
  where sta
  </code></pre>
  
  <p>This query doesn't pull up anything after the where clause regardless of if I type any characters or not</p>
  
  <pre><code>select *
  from tbl_assignment
  where 
  </code></pre>
  
  <p>Furthermore, if I join a table that is working properly with one that is not, no column-level intellisense works:</p>
  
  <pre><code>select *
  from tbl_cash_stats
  join tbl_assignment
      on 
  </code></pre>
  
  <p>I have refreshed local cache several times with no success. There appears to be no specific reason why certain tables work perfectly and others do not, and only about 15% of the tables are affected.</p>
  
  <p>Does anyone have an idea of how to fix this? It has become extremely annoying because it is affecting some of the tables I use most often.</p>
  
  <p><strong>EDIT: After looking into the tables that were affected more closely, it appears that it is only tables with an identity column that do not work with intellisense, but I still cannot figure out why.</strong></p>