Page 1 of 1

Extract DDL for proc, views, triggers

PostPosted: January 12th, 2009, 6:52 pm
by Marcelo Salas
Hi...

I'm using a treeview object for navigating Database objects in my application and I need to display DDL information about store procedures, views and triggers stored in Firebird databases.

Does anybody knows about a component, program or library that extracts DDL of procedures, views or triggers?

Regards
Marcelo Salas

Note.- I'm using IBDAC Data Access Components for Firebird.

Re: Extract DDL for proc, views, triggers

PostPosted: January 15th, 2009, 8:10 am
by Kambiz
As I know, Firebird does not have any SQL command for reverse engineering. But you can use system tables directly to get those information.

By the way, I moved your post to "Delphi Programming" section.