SQL Server Query Shortcuts

Sometime back I detailed the command to describe the details a database table for Microsoft SQL Server. To detail the a given database table you can use the sp_help command. If you don’t want to type sp_help every time you want to see the structure of a table you can use a query shortcut. Microsoft SQL Server Management Studio Express has a series of shortcuts, available under the Options | Options menu. You can add custom query shortcuts. The shortcut for sp_help is Alt + F1. Just select a table name and hit Alt + F1 to see the table details. If no table is selected you will get details on all the available tables.

SQL Server Query Shortcuts

Technorati Tags: , , , ,

Favorite Programming Quotes 2007 »
« Developing Your Programmer’s Intuition
 
Related Posts
Recent Posts
 

2 Comments so far

  1. What is SQL? on November 20th, 2007

    Why do you use Microsoft SQL Server? It has many security vulnerabilities. Why not MySQL or even Oracle?

  2. TechKnow on November 20th, 2007

    As far as I am concerned, I could care less as long as the database is right for the job. I use MySQL and Oracle too.

    It is my experience that project managers, in the end, decide what platform or vendors to use based on their perceptions about resources, expertise and risks.

Leave a reply