Saturday, July 31, 2010

Shortcut Key for Table Details in Sql Server Management Studio

If you select a table name in the query window of Sql Server Management Studio
and press ALT + F1 it will display the details of that table.

In the background shortcut key will execute sp_help on your behalf, so in this example it executes: sp_help users, which is much quicker than typing it.

I'm running Sql Server Management Studio 2008 R2 (but i'm pretty sure it'll work with earlier versions)

10 comments:

Jacqueline.A said...

Thanks. I forgot the shortcut key and was searching for this.

maC blog said...

Very helpful. I had used sp_columns over table but this seems easier and brings more informations.

Wk said...

Very helpful, thanks!

Desh said...

Very helpful for beginners

Andrew Goel said...

Thank a lot, I was searching for this..

Unknown said...

Thankssssssssssss

Unknown said...

Thankssssssssssss

Unknown said...

Thanks..............................

Art Bergquist said...

I had to highlight the database name, schema name and the table name (not just the table name) to get it to work.

The reminder as to which hot key to press was helpful.

Art Bergquist said...

I had to highlight the database name, the schema name and the table name (not just the table name) to get it to work.

The tip was a helpful reminder regarding the hot key to use.