What was that field name?

Question

Post reply

What was that field name?

Dave62

SSCertifiable

Points: 7459
More actions
August 5, 2014 at 10:16 pm

#289581

Comments posted to this topic are about the item What was that field name?
August 6, 2014 at 4:01 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 53 total)

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

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 1

Nice one.

When I observed this feature, I was happy 🙂

Thanks

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

pmadhavapeddi22

SSCertifiable

Points: 5306

August 6, 2014 at 12:00 am

#1735489

Learnt something new today 🙂

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names, data types, Identity fields (if any) and lot more.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

Nice question. I use SQLPrompt by Redgate so I immediately get all the column names and data types through the IntelliSense without even doing anything 😎 :w00t:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 5

Koen Verbeeck (8/6/2014)
Nice question. I use SQLPrompt by Redgate so I immediately get all the column names and data types through the IntelliSense without even doing anything 😎 :w00t:

Same here 😛

Thanks

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 6

Iulian -207023

SSCertifiable

Points: 7639

August 6, 2014 at 1:03 am

#1735503

Nice one , thank you for the question

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 7

I noticed it for columns, tables and functions, but I happily surprised for star!

Good!

😀

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 8

Hany Helmy (8/6/2014)
Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names, data types, Identity fields (if any) and lot more.

My ususal practice is alt + F1 (I though this option will be there in the list of answers but no ;-))

uravindarreddy Ten Centuries Points: 1390 More actions · Answer 9

uravindarreddy

Ten Centuries

Points: 1390

August 6, 2014 at 1:37 am

#1735510

A very nice question! This helps a lot!

😀

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 10

Wonderfull!!!

It, also, works with subquery:

SELECT * FROM (

SELECT MAX(object_id) AS ID,MAX(name) AS NAME FROM sys.objects

) AS o

But in this case it states a wrong type for column NAME(int,null)

Sebastian Zeller Valued Member Points: 71 More actions · Answer 11

You could also use a simple table alias to choose from the list of columns 🙂

Select *

FROM dbo.Customers c

WHERE c.

Toreador SSChampion Points: 11368 More actions · Answer 12

I knew what the answer was going to be, so got it right.

But this method will only tell you if a column is (for instance) varchar. It doesn't tell you its precision. To see that the quickest way is to highlight the table name and press Alt-F1. Of the options given, Object Explorer is the only one that includes this information.

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 13

In typical SQL style actually the answer is "it depends" - on how you work.

Hovering the mouse may be quick but not that helpful since as soon as you start typing the list tooltip disappears so if you want more than one from a table with quite a few fields and you really can't remember then that blows that out the water.

I have widescreen monitors (doesn't everyone nowadays?) at 1920 odd res so I have object explorer permanently pinned open. Further when I am working with a particular database (I'm a software dev) I expand Management Studio and typically have either tables or the programmability sections (or both) expanded so for me at wors it is a little bit of a scroll and a couple of clicks to get all the required information (including precision as someone else mentioned).