Extract DDL for proc, views, triggers

If you have a programming question, please feel free to post it here. Non-programming questions will be moved to Miscellaneous or deleted.

Extract DDL for proc, views, triggers

by Marcelo Salas » 12/01/09 18:52

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
Member
Member
 
Posts: 3
Joined: 16/06/08 22:11

Re: Extract DDL for proc, views, triggers

by Kambiz » 15/01/09 08:10

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

Donate a cup of food for free: Click to Give @ The Hunger Site

Kambiz
Administrator
Administrator
 
Posts: 1639
Joined: 07/03/03 19:10
Location: Tehran, Iran


Return to Delphi Programming

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests