---
title: "How to list all tables in a schema in Oracle SQL?"  
description: "How to list all tables in a schema in Oracle SQL?"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159127/how-to-list-all-tables-in-a-schema-in-oracle-sql  
category: "oracle"  
tags: ["database schema", "database table", "oracle"]  
reading_time: 2 minutes  

---

# How to list all tables in a schema in Oracle SQL?

How to list all [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in a [schema](https://www.mindstick.com/articles/1844/how-schema-markup-useful-in-serp) in [Oracle SQL](https://www.mindstick.com/forum/159138/oracle-sql-casting-string-as-date-how-works)?

## Replies

### Reply by Aryan Kumar

Sure, here is how you can list all tables in a schema in [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle) [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database):

SQL

```plaintext
SELECT table_name
FROM user_tables;
```

This query will select all tables in the current user's schema. The `user_tables` view is a data dictionary view that contains information about all of the tables in the schema.

The `table_name` column contains the name of the table.

To run this query, you will need to connect to the Oracle database using a tool like SQL*Plus. Once you are connected, you can run the query by typing it into the SQL*Plus prompt.

For example, to run the query above, you would type the following into the SQL*Plus prompt:

SQL

```plaintext
SELECT table_name
FROM user_tables;
```

This would return a list of all tables in the current user's schema.

You can also use the `all_tables` view to list all tables in the database, including tables that are owned by other users.

Here is the syntax for the `all_tables` view:

SQL

```plaintext
SELECT table_name
FROM all_tables;
```

To run this query, you will need to have the `DBA` role or be granted the `SELECT` privilege on the `all_tables` view.


---

Original Source: https://www.mindstick.com/forum/159127/how-to-list-all-tables-in-a-schema-in-oracle-sql

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.