Board index » delphi » DDL

Sam

Delphi Developer
 

DDL


2007-08-10 01:10:48 AM
delphi163
Is there a SQL statement that gives me the databases DDL?
Thank you
 
 
Bill Todd

Delphi Developer

2007-08-10 01:25:34 AM

Re:DDL

Sam writes:
Quote

Is there a SQL statement that gives me the databases DDL?

Thank you
No.
--
Bill Todd (TeamB)
 
Craig Stuntz [TeamB]

Delphi Developer

2007-08-10 01:33:51 AM

Re:DDL

Bill Todd writes:
Quote
>Is there a SQL statement that gives me the databases DDL?
No.
There is, however, an IBX component which will do it (TIBExtract).
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
Useful articles about InterBase development:
blogs.teamb.com/craigstuntz/category/21.aspx
 

Quinn Wildman (CodeGear Developer Support)

Delphi Developer

2007-08-10 05:58:28 AM

Re:DDL

You can not do it with just one, but you can it with many. :-) Don't think
it would be worth the time to figure out when so many tools can already
do this. Personally, I like extract DDl with isql. Example:
isql yourdatabase -u sysdba -p masterkey -x -o meta.sql
Creates meta.sql with your DDL.
Sam writes:
Quote
Is there a SQL statement that gives me the databases DDL?

Thank you