--- In firebird-support@yahoogroups.com, "scotty_ncc1701_2003"
<scotty_ncc1701_2003@y...> wrote:

>
>
> I'm new to this group, and I was wondering if someone could help

me.

> I was wondering if any one knows where I can find a list of SQL
> statements that would generate the DDL for the databases. I know

that

> there are utilities like EMS IB Manager, IBConsole, even the new SQL
> Hammer (see http://www.ibphoenix.com) that will do this. However, I
> was hoping to find sql statements/procedures/functions that will

help

> me learn more about system tables.
>
> Thanks loads

If you can find the PDF help files (The ones from IB6 are ok) they
have some descritpions of the system tables.

However, the best place I'v found is in the UIB (Unified Interbase)
sources (http://www.progdigy.com/modules.php?name=UIB)

They have a metadata unit that has some great sql statements to pull
out everything you'll ever need.

-Andy