Re: Utility to compare structure of two tables and generate an ALTER TABLE

Charles,

is this for some sort of automated upgrade process?

how ive done this in the past is...

1. copy old to temporary table CREATE TABLE TEMPxxx SELECT * FROM
2. clear old table
3. modify old table ALTER TABLE
4. copy temp table data to modified table SELECT * FROM




On Wed, 16 Oct 2019 at 18:41, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Anybody ever run across a utility that would compare two tables and
generate the necessary ALTER TABLE command to make the second table look
like the first?

Basically, looking for the SQL equivalent of CHGPF SRCFILE()...

Thanks!
Charles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com