Hi Friends,

I know its a basic question but need your help.

When I type Select statemet like below, Tables names are not populate auto. I need to type full lenght instead of selection in list.

Ex: I have few tables and database in my schema and need to select while coding.

select * from (Table Name) When i type first char in the table space it will not populate list of tables in my sql studio. 

Please let me know if you have answer my question. 

Thanks in advance.

You need to install a third party tool, i.e., SQL Assistant to do that.

You need to make sure you have the Intellisence Enabled  enabled in your SSMS.

From SSMS Query (tab)>>Intellisence Enabled

Hi,

you have to type schema first. Default schema is "dbo" so if you want to have intellisense you have to type "dbo." first. Schemas are like folders with security. Dbo means database owner.

Its already enable. No help Tried couple of time. 

Ya, I tried both way but no help. 

ex: select * from emp.dbo.dept;

its not picking up. 

Without this is their otherway..? Its not there for me right now in my system. 

You didn't provide enough information about your instance. You can restart your computer if you like.

I had similar issues with Intellisense not immediately picking up sometimes. What is your SQL Server version, is SQL Server installed locally or remotely, etc.

I have two servers

SQL Server 2005

Sql Server 08 r2

Its in my local system. 

Good day,

Intellisense was added only in SQL Server 2008  as much as I remember. So for SQL 2005 you need third party application. Again... I am not sure about this!

In SQL 2008/r2 there was a bug regarding Intellisense if you installed Visual studio (I dont remember what exactly but it was fixed in the updates).

Do you have VS installed as well ?

** if so, please provide the full version of the VS and the SQL Servers

** You can try using SSMS from newer version to connect older version of the server. For example Using SSMS 2012 to connect SQL 2005. It might work for you (It is related to the SSMS and not the SQL Server)

UPDATE: here i found the documentation on the bug that I mentioned
The IntelliSense feature in SSMS 2008 R2 may stop working after you install Visual Studio 2010 SP1
https://support.microsoft.com/en-us/kb/2531482

Ya, I tried both way but no help. 

ex: select * from emp.dbo.dept;

its not picking up. 

emp.dbo.dept?

What is that emp? It should be dbo.dept

Make sure to use latest SP for SQL Server 2008 R2. Intellisense will only work in that instance, not in SQL 2005.