Find all tables in a database

How to find all the tables existing in a database?

Questions by vinodhinifelix

Showing Answers 1 - 3 of 3 Answers

SELECT TABLE_NAME FROM All_TABLES
Order by TABLE_NAME;

The above query will display all the table names in the database.

SELECT TABLE_NAME FROM USER_TABLES
Order by TABLE_NAME;

The above query will display all the table names in a particular schema.

To view tables in the current schema
SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'

To view all the tables that you have access
SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABLE'

To view all the tables in the database
SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TABLE'


You may use user_tables instead of user_objects.




Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions