Subject | Re: [firebird-support] Checking for UDF |
---|---|
Author | Thomas Steinmaurer |
Post date | 2007-03-21T20:29:08Z |
Hi Roy,
select * from rdb$functions
where rdb$function_name = 'FUNC'
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
> How can I check if a UDF function, say ADDMINUTE, is already declaredBy querying the RDB$FUNCTIONS system table.
> in my firebird database ?
select * from rdb$functions
where rdb$function_name = 'FUNC'
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com