Show Tables query in Oracle SQL

BroCode

Edited On 24 JANUARY 2023

Category: SQL

1 Answers
13 Views
0 Likes

In MySQL, if I have to see all tables in Database, I run query-

show tables;

But above query doesn't work in Oracle SQL. How to view all tables in database schema of Oracle SQL?

1 Replies

Answer Now

To view all tables owned by the current user in Oracle SQL, you query from the user_tables view like-

SELECT table_name
FROM user_tables
ORDER BY table_name;

To view all tables in the entire Oracle Database, you query from the dba_tables view like-

SELECT table_name 
FROM dba_tables;

Published on 24 JANUARY 2023 at 6:28

0 Likes Reply

Ask Question

Users Leaderboard

Online Tools