Short cut key

Question

Post reply

Short cut key

Hari.Sharma

SSCertifiable

Points: 6904
More actions
July 14, 2008 at 1:11 pm

#193899

Comments posted to this topic are about the item Short cut key
Cheers,
Hari
Tips & Tricks for SQL BI Developers

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

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

notquitexena SSCrazy Points: 2674 More actions · Answer 1

Did anyone else notice the date for this QOTD is a month in the future?

Doc Brown rules!

:blink:

OCTom SSChampion Points: 11785 More actions · Answer 2

I'm fairly new to SQL Server so I may not be seeing it. ALT+F1 brings up nothing at all in management studio. Also, isn't sp_help used in code?

:unsure:

Vivien Xing SSChampion Points: 12297 More actions · Answer 3

The link "SQL Server Management Studio Keyboard Shortcuts" is very helpful.

Karl_Chand Old Hand Points: 368 More actions · Answer 4

Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.

Hari.Sharma SSCertifiable Points: 6904 More actions · Answer 5

Karl_Chand (7/14/2008)
Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.

Did you really try this?

Just select a table name and press Alt+F1 and see the result...

Cheers,
Hari
Tips & Tricks for SQL BI Developers

AntonDeski Old Hand Points: 389 More actions · Answer 6

Even though my Studio is set up for the shortcut, it doesn't do anything. Most probably because I've got a soft-KVM and that seems to blat most shortcuts just because it can. 😉

I'll have to try it at home.

Iggy-SQL SSCarpal Tunnel Points: 4169 More actions · Answer 7

I don't have SQL Server 2005 so I can't test, but according to the keyboard shortcut list on BOL (http://msdn.microsoft.com/en-us/library/ms174205.aspx) there is no ALT+F1 at all. Is this a custom keyboard shortcut?

Urbis, an urban transformation company

skyline666 Ten Centuries Points: 1149 More actions · Answer 8

Hari.Sharma (7/14/2008)
Did you really try this?
Just select a table name and press Alt+F1 and see the result...

Just select a table name and press Alt+F1, is that all I have to do? I click on a table name in the object explorer and pressed Alt+F1 and nothing happened, so I made a new query and put the table name in there (with and without the database name), and I received an error:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '.'.

So what do I need to do to see this? Does doing this in Management Studio Express 2005 not work?

PS. I see I wasn't the only one to confuse this with the "How Do I" under Help on the toolbar :hehe:

EDIT:

Why is this QOTD for next month anyway? I know there is a question for this month, and that would have something to do with it.

Øystein Fallo SSCommitted Points: 1835 More actions · Answer 9

You have to enclose the object name in double-quotes when using two-part names (include schema)..

like this : "dbo.spt_values" (in master).

Hari.Sharma SSCertifiable Points: 6904 More actions · Answer 10

As simple as it is:

-- Query

USE [MyDataBase]

GO

TableName -- Bold shows that it is selected

-- Now Press Alt+F1

I think it is very easy and self explanatory.

See the attachment

Cheers,
Hari
Tips & Tricks for SQL BI Developers

Shaun McGuile SSCarpal Tunnel Points: 4111 More actions · Answer 11

Yeah so if I got it wrong cos I obviously havent answered it yet as that would be next month can i have the point back til 15th August and then lose it? 😀

This question is very poor in explanation of what it is asking, like when would you push the help button combo i.e. within a query window or within object explorer?

The QOTD posters should know what pedants we all are - precision is key ambiguity leads to hell 😀

--Shaun

Hiding under a desk from SSIS Implemenation Work :crazy:

skyline666 Ten Centuries Points: 1149 More actions · Answer 12

Hari.Sharma (7/15/2008)
As simple as it is:
-- Query
USE [MyDataBase]
GO
TableName -- Bold shows that it is selected
-- Now Press Alt+F1
I think it is very easy and self explanatory.
See the attachment

Tried that and still got the same error. However, if I removed dbo from the table name, it worked.

Learnt something new, and still earned a point 😎

Hari.Sharma SSCertifiable Points: 6904 More actions · Answer 13

I dont know the reason but it is working on my system without removing dbo 😎

Cheers,
Hari
Tips & Tricks for SQL BI Developers

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 14

Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation linked to. I'm calling shenanigans on this one.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software