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.
10:11 pm
Anonymous 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.
10:11 pm
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)
"Shortcut Key for Table Details in Sql Server Management Studio"
10 Comments -
Thanks. I forgot the shortcut key and was searching for this.
7:52 am
Very helpful. I had used sp_columns over table but this seems easier and brings more informations.
10:41 am
Very helpful, thanks!
6:02 pm
Very helpful for beginners
10:06 am
Thank a lot, I was searching for this..
12:07 pm
Thankssssssssssss
7:48 pm
Thankssssssssssss
7:49 pm
Thanks..............................
7:50 pm
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.
10:11 pm
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.
10:11 pm