Re: Read which UDFs are installed

Article View: borland.public.interbase.sql

Article #261

Back to borland.public.interbase.sql Previous Next

#261

From: Magnus
Date: Tue, 22 Jan 2008 10:42

17 lines
1244 bytes

Stefan Westner wrote:
> Hallo,
> 
> is there a way to read (perhaprs via metatable) which UDFs are
> installed in a database?

select * from rdb$functions
to list all functions

or

select distinct rdb$module_name from rdb$functions
to list the UDFs


-- 
Magnus

Technical Details

Message-ID: <4795c8a8$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <4795c0fc$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,91491da2dee7b58
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 22 Jan 2008 11:42:49 +0100
From: Magnus <magnus.titho@[askme].de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.9) Gecko/20071031 Thunderbird/2.0.0.9 Mnenhy/0.7.5.0
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Read which UDFs are installed
References: <4795c0fc$1@newsgroups.borland.com>
In-Reply-To: <4795c0fc$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 80.146.171.228
Message-ID: <4795c8a8$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1200998568 80.146.171.228 (22 Jan 2008 02:42:48 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message