SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How To Get a List of All Tables in the Database?

Go down

How To Get a List of All Tables in the Database? Empty How To Get a List of All Tables in the Database?

Post by Micheal Tue Jan 19, 2010 8:31 pm

If you don't like to use a SELECT statement to get a list of all tables in the current database, you can use the Reports view to do this as shown in the following tutorial example:
Click menu View.
Selects Reports from the menu.
Open Reports.
Open Data Dictionary Reports.
Open Table.
Double-click User Tables. You see the Enter Bind Values window.
Click Apply.
You should get a list all current tables in the database.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum