Is there a way that i can find out what base tables are being used by views using a custom query or stored procedure?
If this is something you'll be doing often Red Gate SQL Dependency Tracker (no I don't work for them) is a great tool. I think they have a trial period if you want to try it.