Dropping a Stored Procedure

Drop a stored procedure to remove it from your database.

Prerequisites 

Before you can drop a stored procedure, be sure the data server that contains the stored procedure is running, and you created and established a connection to the data server.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Expand the Stored Procedures folder, right-click the stored procedure you want to drop, and choose Drop.
Related concepts
Stored Procedures
Related tasks
Creating a SQL Anywhere or Sybase IQ Stored Procedure
Creating an ASE Stored Procedure
Migrating ASE Stored Procedures to Sybase IQ Syntax
Editing a Stored Procedure
Renaming a Stored Procedure

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com