Page 1 of 1
New table name not updated in "Add Database Column" during Clone of existing object
Posted: Mon Sep 22, 2025 5:15 pm
by Paul
I have changed the name of one of my tables in nubuilder and thought I have changed everything else I needed to in order to make everything work properly, but apparently I have missed something. When I try to add a new column from the "Add database column" button (while cloning an existing object), it displays the "Add Database Column" window, but the ALTER TABLE statement includes the OLD table name, rather than the new one.
What have I missed?
Re: New table name not updated in "Add Database Column" during Clone of existing object
Posted: Mon Sep 22, 2025 5:54 pm
by kev1n
Also rename the table in this location:
Table: zzzzsys_object
Column: sob_all_table
Re: New table name not updated in "Add Database Column" during Clone of existing object
Posted: Mon Sep 22, 2025 6:21 pm
by Paul
Do I need to edit all of the rows (33 rows) where 'pk_location' (old table name) exists?
Re: New table name not updated in "Add Database Column" during Clone of existing object
Posted: Mon Sep 22, 2025 6:37 pm
by kev1n
Yes - you can replace them with an SQL Update:
Code: Select all
UPDATE zzzzsys_object
SET sob_all_table = REPLACE(sob_all_table, 'old_table_name', 'new_table_name')
WHERE sob_all_table LIKE '%old_table_name%';
Re: New table name not updated in "Add Database Column" during Clone of existing object
Posted: Mon Sep 22, 2025 7:00 pm
by Paul
Thank you! That worked. Had to first disable 'Safe Updates' (in MySql Workbench).