sp_stored_procedures

Description

Returns a list of available procedures.

Syntax

sp_stored_procedures [sp_name] [, sp_owner]
 [, sp_qualifier]

Parameters

sp_name

is the stored procedure name. Use the wildcard character to request information about more than one stored procedure.

sp_owner

is the owner of the stored procedure. Use the wildcard character to request information about procedures owned by more than one user.

sp_qualifier

is the name of the database. Acceptable values are the current database or NULL.

Usage

This procedure corresponds to the ODBC function SQLProcedures.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF