The situation is that an organization has moved their SQL server and would like to update existing External Tables in LF by typing in the new database name. The name of the table itself should stay the same. Is it possible to make that update without having to remove the external table from the templates that are using it first? Right now, the method is to create a new external table with the new database name and then go into the templates and replace the old data table with the new one. Some customers want to keep the table name the same for consistency purposes.
Any insight on this would be helpful!