Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
8 / 108
How we can see all the tables in one Schema?
Answer:
Oracle db: We can see all tables in a scheme for curent user by using query 'select * from user_tables'. Dba user can see tables for all users by using query 'select * from all_tables'. Second query will return owner of table too.
Asked In ::
Dejan
23 Feb, 2019 5:07 AM
Oracle db: We can see all tables in a scheme for curent user by using query 'select * from user_tables'. Dba user can see tables for all users by using query 'select * from all_tables'. Second query will return owner of table too.
Vijay
7 Jan, 2021 7:02 PM
There isn't an Oracle show tables command specifically, but the first method is using the dba_tables view. This view shows all of the tables in the database. select owner, table_name FROM dba_tables;