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.

[geetaravula]

even i want answer to the same question by using sql or pl/sql please help me out

[sanereddy]

Originally Posted by geetaravula

even i want answer to the same question by using sql or pl/sql please help me out

Oracle : select * from tabs

SQl Server : select name, user_name(uid) from sysobjects where type='U'
sp_tables

[geetaravula]

Originally Posted by geetaravula

even i want answer to the same question by using sql or pl/sql please help me out

Anyone please help me out to get table names from a view using pl/sql procedure