I need some script that could rename all the tables in my db. I want to replace the spaces with underscores as follows:
Generic Traveler Steps
Also, if possible, replace " - " with _ as follows:
Test - Pull Subtable
Is it possible to write T-SQL script to go through all of my 100 tables and do the above replacements? If so, can you give me an example. My DB is on SQL Server 2005.
Note: For testing and release purposes, I may need to do this renaming several time. Otherwise, I would have just manually changed the name.