Skip to content

Working with Procedure Objects

You can perform the following basic operations on database procedures:

  • Create database procedures

Note

By default, any user can create a database procedure, but this ability can be restricted using database permissions.

  • View existing database procedures, including the detailed properties of each individual object
  • Drop database procedures

In SQL, you can accomplish these tasks using the CREATE PROCEDURE, HELP PROCEDURE, and DROP PROCEDURE statements.