Re: Structure of a table
Posted in 1997
Bill Ennis — — source: Informix-list mailing list archive (1991-1998)
See the dbschema utility.
dbschema -t <table-name> -d <db-name> <outfile> would work for you.
-Bill
note: this will not dump the data. There are other utilities for that.
Sundar Raman wrote:
}
} 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.