View original (French)

SQL List tables in a database

Solved
ruth -  
```sql
SELECT table_name FROM user_tables;
```

4 answers

  1. fouad 
    MONTRER LES TABLES [DE nomdelabase] [COMME "test%"];
    78
    1. tehoden
      false... this is a request for MySQL...

      in oracle:
      List the tables of the current user's schema:

      SELECT table_name FROM user_tables

      List the tables accessible by the user:

      SELECT table_name FROM all_tables

      List all tables (you must be ADMIN):

      SELECT table_name FROM dba_tables
      1
    2. sara
      thank you
      0