MS SQL SP_HELP
MS SQLTodd 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
No comments for this entry.
|| 
Add Comment
Add Comment
Loading....