evBlog

MS SQL SP_HELP

Posted : Feb 22, 2007 1:31 PM

MS SQL

Todd over at <cfsilence > blogged today about SP_HELP. I did not know this stored proc existed but apparently you can run it on any sort of object in your database and it will provide information on that object.

For example I ran:

EXEC sp_help TEAccount

After executing this SP on my table in query analyzer I got 7 result sets returned. The record sets tell you everything about the table, when it was created and by whom. It lists all of the columns in the table, any identity fields, as well as any index information. Give it a shot!

Thanks for the post Todd , keep on keepin on!

Good Day!
Ryan