Ibphoenix has a good article on retrieving some of this information in their
knowledgebase...


http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID=
'72'

http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID=
'127'

Hope these help

N.

> -----Original Message-----
> From: Sundawa [mailto:ysundawa@...]
> Sent: Wednesday, 12 November 2003 14:20
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] How to find List of All Tables,
> Views, Triggers and Stored Procedures
>
>
> Is there any way I can find those items via SQL statement ?
> I know they are stored into some system tables but I just
> don't know which nor to retreat them ..
>
> Plz Help ...
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits
> for your HP, Epson, Canon or Lexmark Printer at MyInks.com.
> Free s/h on orders $50 or more to the US & Canada.

http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/