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 Messag
desc 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 script to
