Extract DDL for proc, views, triggers

Please discuss general Delphi programming topics here.

Extract DDL for proc, views, triggers

Postby Marcelo Salas » January 12th, 2009, 6:52 pm

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.
Marcelo Salas
Active Member
Active Member
 
Posts: 5
Joined: June 16th, 2008, 10:11 pm

Re: Extract DDL for proc, views, triggers

Postby Kambiz » January 15th, 2009, 8:10 am

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.
Kambiz
User avatar
Kambiz
Administrator
Administrator
 
Posts: 2430
Joined: March 7th, 2003, 7:10 pm


Return to Delphi Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron