Subject Changing Columns
Author checkmail

Hello,

 

I would like to change a primary column in my database from 8 to 16 characters. Over 100 Tables are constrained, foreign key reference. Now I can change the DDL from the Database and create this again, but I must import all Data-Tables. An other Option is the changing manually, delete all references, changing and create.

 

Is there another option? Can I change it “offline” without the necessity to import all data or change it manually?

 

Thanks

 

Best regards

 

Olaf