Copy Table Schema ?

Hello, I am running IDS 11.50.FC4 and have a monthly process that requires copying the structure of a table to a new table. Is there any way to copy a table structure in Informix via script without using dbschema ? Also the original table has millions of records and is not fragmented so I would not want to fragment the table and then detach a fragment as it would take too long. Thank You, Dave

davidansel@gmail.com wrote: > Hello, > > I am running IDS 11.50.FC4 and have a monthly process that requires > copying the structure of a table to a new table. Is there any way to > copy a table structure in Informix via script without using > dbschema ? Also the original table has millions of records and is not > fragmented so I would not want to fragment the table and then detach a > fragment as it would take too long. I don't understand: what is wrong with dbschema? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.