Viewing a Stored Procedure

Several system stored procedures provide information from the system tables about stored procedures. Using these stored procedures, you can:

• See 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 owner, 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

Transact-SQL