Re: Copy Table Schema ?

Thank you. I will take a look at your myschema scripts. I have had a few occassions where having a built in feature to at least copy a table structure (minus indexes, constraints, triggers etc.. ) would really be useful. On Tue, Mar 2, 2010 at 9:30 AM, Art Kagel <art.kagel@gmail.com> wrote: > 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 >> >> >