Useful System Stored Procedures

9/14/2020 7:24:00 AM

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.