We have tables that reach the 1024 column limit.
When trying to run a synch to make column changes to these tables. The ALTER TABLE ADDs are processed before the ALTER TABLE DROPs.
This results in a 1024 column limit being exceeded.
We must manually go into the script file and move the DROPs before the ADDs.
When trying to run a synch to make column changes to these tables. The ALTER TABLE ADDs are processed before the ALTER TABLE DROPs.
This results in a 1024 column limit being exceeded.
We must manually go into the script file and move the DROPs before the ADDs.