Sometimes as a developer/DBA you need to do an impact analysis before renaming or dropping a table.

By running sp_depends ‘tablename’ you can determine what objects are using it and be in a better position to assess the impact that your change will introduce.

This little exercise will ensure  that nothing breaks after the change is implemented .