Developer Tip Quickly look up table information in SQL Server Management Studio

20 07 2009

Quickly look up table information in SQL Server Management Studio

July 20th 2009 | Jonathan Cogley

Quickly look up table information in SQL Server Management Studio

You are working on a SQL query joining some tables when you need to know more about one of your tables … you could open another query window and run “sp_help tbUserGroup” OR you can just select the table and hit ALT F1 to do the same thing!

Quickly look up table information in SQL Server Management Studio

thanks to Mark King for showing me this trick

Jonathan Cogley is the CEO of Thycotic Software, an agile software consulting and product development company based in Washington DC. Secret Server is our flagship enterprise password management product.Are you on Twitter? Follow Jonathan

Actions

Information

Date : July 20, 2009
Tags: Developer SQL tip, Developer tip, SQL shortcut, table information SQL, table query SQL, table SQL shortcut
Categories : SQL

2 responses

21 07 2009: Dew Drop – July 21, 2009 | Alvin Ashcraft's Morning Dew (08:59:43) :

[...] Developer Tip Quickly look up table information in SQL Server Management Studio (Jonathan Cogley) [...]

Reply
10 08 2009: Developer Tip Get column names for a SQL query | Thycotic Software Ltd. | Team Blog (11:58:15) :

[...] tip combines an earlier tip to show an easy way to grab the columns of a table and use Regular Expressions to format your [...]

Reply

Thycoticsolutionsblog's Blog