| Subject | Re: [firebird-support] How to get DDL for a database table? |
|---|---|
| Author | Pete Cervasio |
| Post date | 2010-01-14T21:45:18Z |
On Thursday 14 January 2010 15:11:22 Doug Chamberlin wrote:
/opt/firebird/bin/isql -a -u user -p pass localhost:dbfile
but on a table level, instead of seeing all the meta-data for the entire
database.
Rael, you might try something like the above (which works in Linux, at least)
with the output redirected to a file, or with the -o switch to automatically
write to a specified file. The table you want will be in that output (along
with a lot of other DDL).
Pete C.
--
=====================================================================
"The moral of the story is that with a contrived example you can
prove anything. Oops. No, that's not what I meant to say."
-- Joel Spolsky
=====================================================================
> rael_bauer wrote:I believe he's looking for the equivalent to
> > I've wondered for a long time how to do this.
> >
> > Can someone enlighten me?
>
> How to do what?
/opt/firebird/bin/isql -a -u user -p pass localhost:dbfile
but on a table level, instead of seeing all the meta-data for the entire
database.
Rael, you might try something like the above (which works in Linux, at least)
with the output redirected to a file, or with the -o switch to automatically
write to a specified file. The table you want will be in that output (along
with a lot of other DDL).
Pete C.
--
=====================================================================
"The moral of the story is that with a contrived example you can
prove anything. Oops. No, that's not what I meant to say."
-- Joel Spolsky
=====================================================================