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,464 KB - Version: 7.7.0

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.

"I would like to say again how much time your product saves me and how I truly appreciate the responsiveness of the support you provide."

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