1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Hello,
Instead of SHOW TABLES
, how about using the information_schema table?
SELECT * FROM information_schema.tables WHERE table_schema = 'database'
If you want to pull views separately, query the information_schema.views
table.
Contenus pertinents
- demandé il y a un an
- demandé il y a 8 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
Hi, thanks for your response. That doesn't work.
The view in my database is listed in
information_schema.tables
whileinformation_schema.views
is empty. How is that possible at all?