Re: Structure of a table

Posted in 1997

Vic Goldberg — Thu, 02 Oct 1997 12:52:51 -0400 — source: Informix-list mailing list archive (1991-1998)

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. dbschema -d database -t table > filetostoreinto.sql hth Vic -- Vic Goldberg Manager, Database Administration Team Cornell Information Technologies (607) 254-7441 (voice) (607) 255-6982 (fax)