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 + '.' +
  FROM sysobjects a, sysusers b
 WHERE a.type = 'SF'
   AND a.uid = b.uid


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

SQL Server

IF OBJECT_ID('sys.schemas') IS NULL
    SELECT + '.' +
      FROM sysobjects A, sysusers B
     WHERE A.type IN ('FN', 'TF')
        AND B.uid = OBJECTPROPERTY ( , 'ownerid' )
ELSE     SELECT + '.' +
      FROM sysobjects A, sys.schemas B
     WHERE A.type IN ('FN', 'TF')
       AND B.schema_id = A.uid
     ORDER BY + '.' +

SQL Anywhere

SELECT + '.' + a.proc_name
  FROM SYSPROCEDURE a, sysusers b
 WHERE a.creator = b.uid
   AND substr(left(proc_defn,8), 8, 1) = 'f'
 ORDER BY, a.proc_name
SQL Query Tool Download
QweryBuilder Trial
20,463 KB - Version: 7.7.1

QweryBuilder is an advanced SQL Query Tool and SQL Editor. Its purpose is to help you extract information from your database in a way that is 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
SQL Query Tool  |  SQL Editor  |  Database Development Tool  |  SQL References  |  Testimonials
Copyright © 2008-2015 Werysoft Inc. All rights reserved.
Follow us on:   Join us on Facebook Follow us on Twitter Join us on Google+ Read our blog