Re: Copy Table Schema ?

There is nothing wrong with dbschema - just requires a little bit of parsing. I was wondering if there was any built in database SQL command. I know there is the create table SAMEAS clause however that only applies to external tables and I know there is CREATE DUPLICATE statement to create a duplicate copy of an existing table though that is only for XPS. Anything for IDS? --Dave On Tue, Mar 2, 2010 at 9:12 AM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > 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. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >