|
The following SQL can be used to query your database system tables for a list of stored procedures. With the exception
of Oracle, each query returns the stored procedure name with the appropriate schema\owner name appended to it.
Oracle simply returns the name of the stored procedure.
Sybase ASE
SELECT b.name + '.' + a.name
FROM sysobjects a, sysusers b
WHERE a.type = 'P'
AND a.uid = b.uid
ORDER BY a.name
Oracle
SELECT OBJECT_NAME
FROM all_objects
WHERE owner = :sOwner
AND object_type = 'PROCEDURE'
SQL Server
IF OBJECT_ID('sys.schemas') IS NULL
SELECT B.name + '.' + A.name
FROM sysobjects A, sysusers B
WHERE A.type = 'P'
AND B.uid = OBJECTPROPERTY ( A.id , 'ownerid' )
ORDER BY A.name
ELSE
SELECT B.name + '.' + A.name
FROM sysobjects A, sys.schemas B
WHERE A.type = 'P'
AND B.schema_id = A.uid
ORDER BY B.name + '.' + A.name
SQL Anywhere
SELECT b.name + '.' + a.proc_name
FROM SYSPROCEDURE a, sysusers b
WHERE a.creator = b.uid
AND Substr(Left(proc_defn,8), 8, 1) = 'p'
ORDER BY b.name, a.proc_name
|
|
QweryBuilder is an SQL Editor and Query Tool. Its purpose is
to make accessing information from a database simple, quick, accurate and
efficient.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
|
"QweryBuilder is a great, easy to use tool, that is a part of my everyday programmer life."
Read More Testimonials
|
|
|
