Dependancy Renaming Tool

[MayoorPatel]

Hi there I want to rename a Table and the columns inside it too.

The problem with this is that there are countless stored procs that refernce this table and within those stored procs, columns which reference that table.

I'm looking for a tool that will allow me to rename the table and columns I need, and then it just goes ahead and renames all the dependancies too.

Any ideas folks?

 

[SQLDenis]

yesterday MS released something called Visual Studio Team Edition for Database Professionals

from their FAQ
What is Database Rename Refactoring?

Database Rename Refactoring is a method of performing cascading updates to database schema. This allows you to make a change to the name of any object in the database schema (i.e. a Table, Column, Stored Procedure etc) and have that change made everywhere that object is referenced in the database schema.

http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/