<div>
right-click on the Tables and Select Refresh, or hit Ctrl-shift+R, to refresh intellisense 
</div>


right-click on the Tables and Select Refresh, or hit Ctrl-shift+R, to refresh intellisense

<div>
Hi and thanks foir answer,<br />
<br />
As I said above I've already tried both those options already, but that doesn't solve it.<br />
<br />
Peter
</div>


Hi and thanks foir answer,

As I said above I've already tried both those options already, but that doesn't solve it.

Peter

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm developing with sql server 2008 express. When I create a new table the table doesn't show up directly in the query window when I create a query with intellisence activated. Older tables are there but it takes al long time (often a day or so) until the newly created tables show up for intellisence in the query window.<br />
<br />
I've tried to refresh the tables view and also gone to Edit/Intellisence/Refresh Local Cache, but still they don't show up until a long while later. I also restarted the service for sql server without result.<br />
<br />
How can I make them available directly instead of hours later.<br />
<br />
Peter
</div>
</div>


Hi,

I'm developing with sql server 2008 express. When I create a new table the table doesn't show up directly in the query window when I create a query with intellisence activated. Older tables are there but it takes al long time (often a day or so) until the newly created tables show up for intellisence in the query window.

I've tried to refresh the tables view and also gone to Edit/Intellisence/Refresh Local Cache, but still they don't show up until a long while later. I also restarted the service for sql server without result.

How can I make them available directly instead of hours later.

Peter

Tables don't show up in query editor

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.