Stored Procedure Properties

Use the stored procedure Properties wizard to access and modify information on stored procedures.

Click Properties on your stored procedure to initiate the Properties wizard.

Wizard Option Stored Procedure Properties
General
  • View the name, type, database, owner, creation date, and group number of the procedure.
SQL
  • View the SQL statements for creating the procedure.
Parameters
  • View the name, type, mode, and order of all the procedure parameters. The mode value indicates whether it is an input or an output parameter. The order is a numeric value that indicates the place of the parameter in the list of parameters.
  • To change the parameters, change the definition of the stored procedure by dropping and re-creating the procedure.
Permissions
  • Grant and revoke permissions on a procedure to users, groups, or roles. Choose the Grant option to allow the grantee to further grant permissions to other users. Select an object in the table of permissions, and click Properties to view the object properties.
Referenced By
  • View the name, type, owner, and properties of objects that this procedure references. Click an object, then click Properties to view the object properties.
References
  • View the name, type, owner, and properties of objects that this procedure references. Click an object, then click Properties to view the object properties.
Related concepts
Extended Stored Procedures
Related tasks
Creating a SQLJ Procedure
Creating a Stored Procedure