unable get table list from database

[expired user #9037]'s profile image [expired user #9037] posted 9 years ago in Running SQL scripts Permalink
hi,

I am unable get tables list from database in c# using ODBC connection but am getting only count of the tables but not table names, when I execute below query in database query page I am getting all tables from database.

Query:(SELECT table_names FROM information_schema.tables where table_schema=DATABASE())

so please suggest me how to get table list with names from database.

thanks,
jaipal

Please login to leave a reply, or register at first.