Intellisense - Table definition (hover over *)

Question

Intellisense - Table definition (hover over *)

Bruce Edney

SSC Veteran

Points: 245
More actions
November 14, 2012 at 7:00 pm

#284840

Hi
Is there a way to make Intellisense display the column sizes when you hover over a column name or * in SMSS 2012? This was a great feature in 2008 but it does not seem to be in 2012. This mean you need to go to Object Explorer when building temp tables etc. Very frustrating
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Pearce SSCoach Points: 15999 More actions · Answer 1

Bruce Edney (11/14/2012)
This mean you need to go to Object Explorer when building temp tables etc. Very frustrating

If you highlight a table name in a query window and press ALT+F1 you will get column details.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Bruce Edney SSC Veteran Points: 245 More actions · Answer 2

Thanks Artoo - That is a handy tip - So I take it that Intellisense is no longer able to display this info on "hover over"

Lowell SSC Guru Points: 323518 More actions · Answer 3

Bruce I've got both 2008 and 20012 installed; although the formatting/font is different for the tooltip on mouseover, i get the same information...

if you create a NEW table, that table is not in the intellisense until you refresh cache via Control + Shift + R (Edit...intellisense...Refresh Local Cache

could that be what you are seeing?

EDIT: I see what you are saying...2008 shows stuff like varchar(50),null

2012 only shows the datatype,a nd not the size...never noticed that before!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Bruce Edney SSC Veteran Points: 245 More actions · Answer 4

Hi Lowell

No I know about the refresh local cache

the issue is no column size display in the hover over feature (see attached files)

Regards

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

Bruce Edney (11/20/2012)
Hi Lowell
No I know about the refresh local cache
the issue is no column size display in the hover over feature (see attached files)
Regards

That looks like it is a third party plugin and not part of SSMS.

--EDIT--

Looking through the other responses maybe there is something I have been missing all along. I have never had anything like when I hover over a table or column name.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/