1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
2
In order to get all the tables in schema "xx.yy", please write the query in following manner: SELECT table_name, table_schema, table_type FROM information_schema.tables where table_schema="xx.yy"
This should help you in getting the desired information.
répondu il y a 10 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 10 mois
- AWS OFFICIELA mis à jour il y a 3 ans
yes, i can get tables use single quote: SELECT table_name, table_schema, table_type FROM information_schema.tables where table_schema='xx.yy'