sp_help procedure_name- View the information about the stored procedure like parameter names, their datatypes etc. sp_help can be used with any database object, like tables, views,SP’s triggers etc. Altematively, you can also press ALT+F1 when the name of the object is highlighted.
Sp_helptext procedure_name- View the text of the stored procedure.
Sp_depends procedure_name- View the dependencies of the stored procedure. The system SP is very useful, especially if you want to check, if there are any stored procedures that are referencing a table that you are abput to drop. Sp_depends can also be used with other database objects like table etc.