|
There are various ways of achieving this. You can give command as
sp_depends sample
where sample denotes the view name. Replace sample with your view name.
or you can also give the query as below:
select * from information_schema.view_table_usage;
These would help you get a report of all the table names used in my views alone.
|