Change Table Names in MSSQL 2000 and NOT break stored procedures and views!
Posted on 2004-10-08
I want to change table names by using strored procedure (or other method) for example:
EXEC sp_rename 'currentTable', 'newTable' and at the same time I want to change embedded scripts pointing to such table/s in existing stored procedures and views. Can this be done in some programmatic (sp?) way as if you use EXEC sp_rename only the tabe name is changed and scripts in sp/views will not work unless I go through them one by one...a massive piece of work indeed in this case :(