Re: Copy Table Schema ?

No. Nothing. You could probably take the myschema source from my utils2_ak package and cobble something up that adds a feature to get a table's structure and output a different name. You'd have to figure out what to do about indexes and other objects like constraints and triggers or to just shortcut out of creating them. Not a feature I'd want to put in for general use though. Too many different ways to want it done. All of the mainline table name code is in the main file myschema.ec. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Mar 2, 2010 at 9:20 AM, Informix DBA <in4mixdba@gmail.com> wrote: > 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 >> > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >