Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

using ER to clone a table with different column type

  • 1.  using ER to clone a table with different column type

    Posted Tue January 20, 2026 01:03 PM
    Keep the schemas the same for loopback then trigger on the target to move the row into the new table.

    But why can you just insert into new select * from old ?

    Cheers
    Paul

    On 1/20/2026 11:49 AM, Jacobo BC via IBM TechXchange Community wrote:
    0100019bdc86fed4-36cf8fdd-781c-4a75-ba4f-f262b63f6c1d-000000@email.amazonses.com">
    Is it possible to use ER to loopback clone a table but altering it so you can change a serial into int8 or serial8? I'm against a brick wall. I...


Related Content