What's the preferred way of checking if a table (in the database I'm using) with a certain name already exists? I am using PEAR's DB class to talk to MySQL and I have an installer script that ...

We are developing a VB6 application that uses MySQL as it's database. The tables are InnoDB. How do we check to see if a record/table is locked before we do ...