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

---

# How to get a list of all tables in Oracle?

How to get a list of all [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle)?

## Replies

### Reply by Aryan Kumar

There are a few ways to get a list of all tables in Oracle. Here are a few of the most common methods:

- **Using the** `all_tables` **view:** The `all_tables` view is a data dictionary view that contains information about all of the tables in the database. You can use the `SELECT` statement to select the `table_name` column from the `all_tables` view to get a list of all tables.

SQL

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

- **Using the** `user_tables` **view:** The `user_tables` view is a data dictionary view that contains information about all of the tables in the schema that the user is currently logged in to. You can use the `SELECT` statement to select the `table_name` column from the `user_tables` view to get a list of all tables in the current schema.

SQL

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

- **Using the** `DBA_TABLES` **view:** The `DBA_TABLES` view is a data dictionary view that contains information about all of the tables in the database, including tables that are owned by other users. You can use the `SELECT` statement to select the `table_name` column from the `DBA_TABLES` view to get a list of all tables in the database.

SQL

```plaintext
SELECT table_name
FROM DBA_TABLES;
```

Which method you use will depend on your specific needs. If you need a list of all tables in the database, then you can use the `all_tables` or `DBA_TABLES` views. If you only need a list of tables in the current schema, then you can use the `user_tables` view.


---

Original Source: https://www.mindstick.com/forum/159125/how-to-get-a-list-of-all-tables-in-oracle

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