Show All Tables in Your Schema in Oracle


How To List All Tables in Your Schema in Oracle?



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.


Managing Oracle Database Tables

⇒⇒Oracle Database Tutorials

2016-10-17, 136👍, 0💬