List Available Tables in a Schema

Your rating: None Average: 3 (4 votes)

Very straight forward query to list all available tables under a specific schema. Our schema name in this example is going to be 'HR'.

SELECT table_name
FROM all_tables
WHERE owner = 'HR';

Results:

TABLE_NAME                    
------------------------------
REGIONS                        
LOCATIONS                      
DEPARTMENTS                    
JOBS                          
EMPLOYEES                      
JOB_HISTORY                    
COUNTRIES                      

7 rows selected

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!