Forum Stats

  • 3,852,814 Users
  • 2,264,140 Discussions


Constraints are dropped after tablecolumn change

Thomas S
Thomas S Member Posts: 4 Red Ribbon

Hello, I have the problem that constraints are dropped, although they should still be there.

I started with a master and a child Table

I deployed these table with sqlcl on a second instance.

After that, i changed on my Sourceinstance the column "data1" in the Table child_test from 20 to 50 byte.

With lb genschema, i generate the new Objects and deploy this, with all the other objects, again.

The column changes have been imported.

But what happend with my FK vom child_test to master_test?

He disappeared!

The logs from sqlcl/lb confirm this to me.

This currently means that after a change to a table column, all constraints may be dropped and that's all, but not a good idea.