Download

The SQL Editor that was designed with you in mind.

Home About Product Features Screenshots Videos Download\Purchase Support Forum

Query Your Database for a List of Functions


The following SQL can be used to query your database system tables for a list of functions. With the exception of Oracle, each query returns the function name with the appropriate schema\owner name appended to it. Oracle simply returns the name of the function.

Sybase ASE

SELECT b.name + '.' + a.name
  FROM sysobjects a, sysusers b
 WHERE a.type = 'SF'
   AND a.uid = b.uid
 ORDER BY a.name

Oracle

SELECT OBJECT_NAME
  FROM all_objects
 WHERE owner = :sOwner
   AND object_type = 'FUNCTION'

SQL Server

IF OBJECT_ID('sys.schemas') IS NULL
    SELECT B.name + '.' + A.name
      FROM sysobjects A, sysusers B
     WHERE A.type IN ('FN', 'TF')
        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 IN ('FN', 'TF')
       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) = 'f'
 ORDER BY b.name, a.proc_name
SQL Query Tool Download
QweryBuilder Trial
20,464 KB - Version: 7.6.3

QweryBuilder's SQL Editor provides you with a rich ad-hoc query experience that gives you full control while you query your database.

Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in one single application.

"This is a great program, a good developer's tool. It is snappy and to the point. It is the best that I have seen and tried."

Read More Testimonials
SQL Query Tool  |  SQL Editor  |  Database Development Tool  |  SQL References  |  Testimonials
Copyright © 2008-2013 Werysoft Inc. All rights reserved.
Follow us on:   Join us on Facebook Follow us on Twitter Join us on Google+ Read our blog