Table Name Change?

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I have a table, that I want to change its name to be more descriptive to
better distinguish between it and a similar table.

The problem is I have many quires that use the existing table. Is there a
way to change the table name and have all the downstream quires pickup the
new table name, so that I do not have to manually open every query and add
the new table name and reestablish all the appropriate links?

Thanks
Harold
 
Some versions use the AutoNameCorrect feature, but I don't
know if I trust it.

There are 3rd party tools (SpeedFerret from Black
Moshannon) that will help with this.

Otherwise, since the Users are NEVER going to see the
database window, it might not matter, as long as you have
the name documented. Unless you absolutely HAVE to rename
the table, I wouldn't. And then if you do, make a backup
copy before you make that change.


Chris Nebinger
 
Back
Top