How To Get a List of All Tables in the Database

Q

How To Get a List of All Tables in the Database? - Oracle DBA FAQ - Introduction to Oracle SQL Developer

✍: FYIcenter.com

A

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.

2007-04-27, 5016👍, 0💬