@Syed Ismail
If you are renaming the metastore, you will need to update the configuration files of the workspaces to point to the new metastore location. You can typically do this by updating the configuration files of the workspaces to include the new metastore location.
Additionally, you may need to update any scripts or code that reference the old metastore location to use the new one. This will depend on how your code is written and how it interacts with the metastore.
It's always a good idea to test your changes thoroughly before deploying to production to ensure that everything is working as expected.