Only so much of this can be automated. You also need to look for things that reference views or stored procs because there could be a restriction down the line. sys.sql_modules can help find some stuff. You can see if the table name and the column name is in the object definition. If you use * anyplace then you can only find that the table is used.