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.
Technorati Tags: ms, sql server, sql, query, shortcuts
Related posts:
2 Comments
Why do you use Microsoft SQL Server? It has many security vulnerabilities. Why not MySQL or even Oracle?
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.