How can I query the database to know that a specific table exists in a
given database.
for example my database is MessageNotification and I want to know if
Message_data table exists in this database. I am using Mysql++ to query
the database.
Thanks in advanced
Tiwonge
desc tablename does the trick from the console or via a query. Checking
for the datafiles is another way if you are local to the server; though,
that's not really a sane technique since you have to usually have the
permissions of the database to see the datafiles.. privs you probably
don't your
1. mysql SHOW databases;
2. mysql USE MessageNotification;
3. mysql SHOW TABLES FROM MessageNotification;
hth
At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote:
How can I query the database to know that a specific table exists in a
given database.
for example my database is