Want to Get Table Names

[caradoc]

I have written many views for performing various operations in my database. I have to now get a report of all the table names used in my views alone. Is there any way for that? Do I need to write some function of procedure for achieving this. Kindly give me some tips for doing this.

[cyrus]

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.

[abhijitbuchake]

Originally Posted by caradoc

I have written many views for performing various operations in my database. I have to now get a report of all the table names used in my views alone. Is there any way for that? Do I need to write some function of procedure for achieving this. Kindly give me some tips for doing this.

u can use
show create view view_name;
command.