Subject Changing Columns
Author checkmail



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?




Best regards