---
title: "Command to get all tables from an oracle database?"  
description: "Command to get all tables from an oracle database?"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159133/command-to-get-all-tables-from-an-oracle-database  
category: "oracle"  
tags: ["database", "database table", "oracle"]  
reading_time: 2 minutes  

---

# Command to get all tables from an oracle database?

[Command](https://www.mindstick.com/blog/178/synchronous-and-asynchronous-command-execution-in-c-sharp-dot-net) to get all [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) from an [oracle database](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)?

## Replies

### Reply by Aryan Kumar

There are a few different commands that you can use to get all tables from an [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle) [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax). Here are a few of the most common commands:

- `SELECT table_name FROM all_tables;` This command will return a list of all tables in the database, including tables that are owned by other users.
- `SELECT table_name FROM user_tables;` This command will return a list of all tables that are owned by the current user.
- `SELECT table_name FROM dba_tables;` This command will return a list of all tables in the database, including tables that are owned by the DBA (database administrator).

The `all_tables`, `user_tables`, and `dba_tables` views are all data dictionary views. Data dictionary views are special views that contain information about the database, such as the names of tables, columns, and users.

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

For example, to run the `SELECT table_name FROM all_tables;` command, you would type the following into the SQL*Plus prompt:

SQL

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

This would return a list of all tables in the database, including tables that are owned by other users.


---

Original Source: https://www.mindstick.com/forum/159133/command-to-get-all-tables-from-an-oracle-database

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