Re: Structure of a table
Yes there is:
dbschema -d database-name -t table-name >filename.sql
Now you have an sql file with the create statement for that table.
You may have to edit the file and delete the first few lines.
---------------------------------------------------------------------------
Jeff Lanham jeffl@etcscan.com
DBA UIN: 2721788
SCAN/Deluxe Payment Protection Systems, Inc.
Bothell, WA
----------
> From: Sundar Raman <sraman@usagl.com>
> To: informix-list@rmy.emory.edu
> Subject: Structure of a table
> Date: Thursday, October 02, 1997 9:02 AM
>
> i'm new to infoxmix so forgive me for a simple question. Is there any
way
> that i can dump the structure of a table to a file. basically i want the
> create table statement that created the existing table so that i can> recreate it on another database (not informix). i'm doing this for
backup
> purposes.
>
> thanks for the help.