DBI has some newer table methods (tables and table_info) that may be useful here. Short of that, you can either eval the prepare call or set the DBI RaiseError attribute to false and check for errors.

Search the DBI docs above for RaiseError and you'll find it's all very well documented. Support for the table methods may be database specific ... check the DBD::mysql docs for specifics.