CODEWITHSUNDEEP
mysqlodbc
Eduardo Molteni
Eduardo Molteni

Reputation: 39413

MySQL: how to get the list of tables using ODBC

I am connecting to a MySQL DB trough a terminal who only have a program with an ODBC connection to a MySQL DB. I can put querys in the program, but not access MySQL directly.

I there a way to query the DB to obtain the list of tables?

Upvotes: 2

Views: 3440

Answers (1)

Sebastian Hoitz
Sebastian Hoitz

Reputation: 9373

There is a SQL query:

Show tables;

You should be able to execute that query.

Upvotes: 5

Related Questions