Viewing details about system procedures and functions

Database administrators can access the definitions for system procedures and functions from Sybase Central.

Prerequisites

DBA authority.

Context and remarks

Many.

 View details about system procedures and functions

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. Right-click the database and then click Configure Owner Filter.

  3. Click DBO and then click OK.

    Note

    The openxml system procedure is the only procedure that is not owned by the dbo user. You cannot view information about openxml from Sybase Central.

  4. In the left pane, double-click Procedures & Functions.

  5. In the left pane, select the procedure and in the right pane click the SQL tab.

Results

The procedure or function definition appears on the SQL tab.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1