How To List All Tables in Your Schema


How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables



If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script:

SQL> connect HR/fyicenter

SQL> SELECT table_name, status, num_rows FROM USER_TABLES;
TABLE_NAME                     STATUS     NUM_ROWS
------------------------------ -------- ----------
REGIONS                        VALID             4
LOCATIONS                      VALID            23
DEPARTMENTS                    VALID            27
JOBS                           VALID            19
EMPLOYEES                      VALID           107
JOB_HISTORY                    VALID            10
COUNTRIES                      VALID            25

7 rows selected.

2007-05-04, 4480👍, 0💬