Subject | Re: [firebird-support] System Tables |
---|---|
Author | Martijn Tonies |
Post date | 2005-04-06T08:28:05Z |
> I'm new to this group, and I was wondering if someone could help me.There's no list of SQL statements that can do this.
> 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.
You can get the info from the system tables to do this, but it's not
as easy as with, for example, MS SQL that there's a procedure
that returns the DDL for your objects.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com