Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Viewing Stored Procedures

Several system stored procedures and catalog views provide information about stored procedures. Using these, you can:

  • See the definition of the stored procedure. That is, the Transact-SQL statements used to create a stored procedure. This can be useful if you do not have the Transact-SQL script files used to create the stored procedure.
  • Get information about a stored procedure such as its schema, when it was created, and its parameters.
  • List the objects used by the specified stored procedure, and the procedures that use the specified stored procedure. This information can be used to identify the procedures affected by the changing or removal of an object in the database.

To view the definition of a stored procedure

To view information about a stored procedure

To view the dependencies of a stored procedure

Community Additions

© 2015 Microsoft