I have think this question few month for my .NET project (winform & webform) or PHP project.
I use Visual Studio 2010 Pro for .NET project and PDT for PHP Project.
Maybe the best way is convert the project to ORM (L2S,EF, PHP ActiveRecord etc) instead of classic SQL statement, however, SQL still quite worth to use, at less every new comer know that on my work place.
I Had to search in google to find any exist plugin or software to do a reflection, but it seem not existing.
So how do you find out which files have to make change when the database schema is change (table name, varchar length, datatype etc) ?
Or just search & replace?