You can try a free addin for SQL Server Management Studio - SQL Refactor Studio (http://sqlrefactorstudio.com/)

Key Features:

- Advanced Search dependences of object (databases, files on disk, query editor)

- Advanced Search dependencies free text (in databases, files on disk, query editor)

- Refactoring "Rename"

- Refactoring "Add CRUD Methods"

- Refactoring "Move columns"

- Refactoring "Add lookup table"

- Formatting SQL code

- And many other useful features!