SQL List tables in a database

Solved

ruth -
sara - 13 May 2018 at 17:21

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

Liens connexes:

4 réponses

Réponse 1 / 4

fouad

MONTRER LES TABLES [DE nomdelabase] [COMME "test%"];

tehoden Posted messages 106 Registration date Status Membre Last intervention 12

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

sara

thank you

Réponse 2 / 4

chibanird Posted messages 3 Status Membre 36

select * from tab;
this command will list all the tables in the database.

nourane

but he told me that the table doesn’t exist, how to access the database to list the tables :(((

Anice Djebbi Posted messages 1 Status Membre

comment faire avec un serveur mysql server 5.6

Dakkers

For me, this command works beautifully, thank you very much!

innconnnnnu

Thanks, the order is working.

I.ismael > Anice Djebbi Posted messages 1 Status Membre


 (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

Réponse 3 / 4

Tony

You tried the following command in SQL+:
select * from cat where table_type='TABLE';

Manu

Thank you very much, that works.

nourane

It works for me this order.

nourane

Désolé, ça ne marche pas.

Claude

It only works with administrator rights.

theo

Nyoko

Réponse 4 / 4

ecco Posted messages 89 Status Membre 26

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.

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!

HUGOBOSS00 Posted messages 46 Registration date Status Membre Last intervention

And for Oracle, how do we do it??

ziedto83

Hello, is there anyone who knows how we can list the tables of a SQL Server database?
Thank you in advance.

DD-10291

We start by selecting the database:
use databaseName;
show tables;
and that's it.

WwiloO

```sql SELECT table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
```

SQL List tables in a database

4 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message

I receive calls from unallocated numbers.

Minecraft restore the cursor and the bar.