SQL List tables in a database

Solved

ruth -

```sql
SELECT table_name FROM user_tables;
```

4 answers

Answer 1 / 4 - Best answer
The best answer is the one that has been validated by our teams.
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
Answer 2 / 4
chibanird
select * from tab;
this command will list all the tables in the database.

36
1. nourane
  
  but he told me that the table doesn’t exist, how to access the database to list the tables :(((
  
  0
2. Anice Djebbi
  
  comment faire avec un serveur mysql server 5.6
  
  0
3. Dakkers
  
  For me, this command works beautifully, thank you very much!
  
  0
4. innconnnnnu
  
  Thanks, the order is working.
  
  0
5. I.ismael
  
  @Anice Djebbi
  
  (in console MYSQL 5.6)
  
  show databases; ==> to display all databases
  connect [database name] ==> to connect to the specified database
  show tables; ==> to display all tables
  Describe [table name] ==> to describe a table in the selected database
  
  0
Answer 3 / 4
Tony
You tried the following command in SQL+:
select * from cat where table_type='TABLE';

17
1. Manu
  
  Thank you very much, that works.
  
  0
2. nourane
  
  It works for me this order.
  
  0
3. nourane
  
  Désolé, ça ne marche pas.
  
  0
4. Claude
  
  It only works with administrator rights.
  
  0
5. theo
  
  Nyoko
  
  0
Answer 4 / 4
ecco
Hello

Indeed, select * from tab; it works, thank you
--
Love gives you a second life, the key is knowing how to seize it and ensuring you keep it.

3
1. l0r3nz1
  
  Hi, unfortunately, that's the kind of request that doesn't work everywhere.
  With Access, it generates an error like the table TAB does not exist!
  
  0
2. HUGOBOSS00
  
  And for Oracle, how do we do it??
  
  0
3. ziedto83
  
  Hello, is there anyone who knows how we can list the tables of a SQL Server database?
  Thank you in advance.
  
  0
4. DD-10291
  
  We start by selecting the database:
  use databaseName;
  show tables;
  and that's it.
  
  0
5. WwiloO
  
```sql SELECT table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
```
  
  0

SQL List tables in a database

4 answers

How to delete groups on a mobile phone

Remove leading zeros in printouts

Unable to boot my acer pc: it doesn't recognize my password

Find a scanner

Ephemeral messages

System error 805306367 my taskbar is inactive

Message saying that my phone is compromised

Very slow computer

Retrieve an email address

Phone alarm plus connected