Find in the database all the store procedures using specific tables or views.
Or list all the tables or view, which the specific Views or StoreProcudres use.

When you try to save a table when you change a column in SQL Server 2008, you will received: “Saving changes is not permitted. The changes you have made require the following tables to be dropped and recreated. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-create.“