Introducing SQL Anywhere Studio
   Tutorial: Managing Databases with Sybase Central
    Lesson 4: View and edit stored procedures

Viewing Stored Procedures

There are several stored procedures included in the sample database. The following steps explain how to view and edit stored procedures.

To view the contents of a stored procedure

1. In the left pane of Sybase Central, open the Procedures & Functions folder in the sample database.

2. Click the sp_customer_list stored procedure.

   You can view the text of the procedure called sp_customer_list on the SQL tab in the right pane:

   

   This procedure is designed to return a set of customer IDs and company names from the customer table.