Hello,
As a newbie to database design I've messed up and named all my tables poorly.
Whilst the queries all work, I've spent a lot of time mapping out all of the
tables and queries & their relationships. I'd like to rename all of the
tables according to their ID on the map, but know that doing so doesn't
update the relationship.
Is there a tool/code that will let me do a 'find and replace' on the SQL
query code to swap out any instances of the old table name with the new table
reference?
Thanks