Stored Procedure Properties

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

Click the Name field of the stored procedure, then click the drop-down arrow and select Properties.

Pages 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.
Referenced By
  • View the name, type, owner, and properties of objects that this procedure references.
References
  • View the name, type, owner, and properties of objects that this procedure references.
Related concepts
Extended Stored Procedures
Related tasks
Creating a SQLJ Procedure
Creating a Stored Procedure