CODEWITHSUNDEEP
sqlintellisensetoad
tom
tom

Reputation: 1822

Bring up toad intellisense

When typing a query in Toad it usually brings up an intellisense scrolling box to help with my typing.

But sometimes this does not appear. Is there a short cut (like in Visual Studio) to bring it up?

EDIT I found that the key mapping is CTRL+.

For a query like 

SELECT * FROM Person AS P
WHERE P. -- I expect intellisense to show me the columns. 
         -- Sometimes it does not and pressing the CTRL+. does nothing

Pressing CTRL+. away from a query brings up a very long list of things like -

@@CONNECTIONS @@CPU_BUSY @@CURSOR_ROWS @@DATEFIRST @@DBTS @@ERROR

Do I have the correct shortcut key?

Is the problem that Toad can't figure out the column names in the query above?

EDIT 2

Very strange behavior

If I have 

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

BUT if I have the following in the editor - 

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

USE DB2 
SELECT * FROM Company AS C
WHERE C. -- No intellisense

Solution below in my own answer

Upvotes: 6

Views: 10456

Answers (4)

Sanket More
Sanket More

Reputation: 1

You have to complete first query to get intellisense in second one. So if you complete first query i.e.

USE DB1
SELECT * FROM Person AS P
WHERE P.FirstName = ‘Sanket’

Then only you can get intellisense in second query. 

USE DB2 
SELECT * FROM Company AS C
WHERE C. --Get the intellisense

Upvotes: -1

tom
tom

Reputation: 1822

It seems if there is a second USE on the page intellisense will not work with queries below the second USE!

If I have

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

BUT if I have the following in the editor -

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

USE DB2 
SELECT * FROM Company AS C
WHERE C. -- No intellisense

It seems if there is a second USE on the page intellisense will not work with queries below the second USE!

Upvotes: 1

evilone
evilone

Reputation: 22740

I suggest you to use CTRL+T combination. I used it and it works. Also Dell official support agrees, here too. Toad is not the greatest software for best user experience :)

Upvotes: 11

Rachel Gallen
Rachel Gallen

Reputation: 28583

CTRL-TAB will bring it up for you.

hope this helps!

Upvotes: 1

Related Questions