Skip to content
Advertisement

How to get the schema name when I have table name – Oracle

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

Advertisement

Answer

Select owner
from dba_tables
where table_name = 'YOUR_TABLE_NAME'

Here you can find something more.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement