CODEWITHSUNDEEP
sqloracle-database
bin
bin

Reputation: 131

How to get the schema name when I have table name?

I have a table name but I am not sure in which schema that table exists. How to find the schema name?

Upvotes: 10

Views: 53582

Answers (2)

z atef
z atef

Reputation: 7679

Something like this should get the name of the table and the the schema it belongs to . 

select owner, table_name 
 from all_tables 
 where table_name like 'GL%';

Upvotes: 11

Aleksej
Aleksej

Reputation: 22949

Select owner
from dba_tables
where table_name = 'YOUR_TABLE_NAME'

Here you can find something more.

Upvotes: 16

Related Questions