How can I check if a table exists...

I want to check if a table exists before i try to access it. Can anyone help me?

Thanks

Are you looking to check this in php? Here is something I use to check for the existence of a table using php and mysql....

$table_exist = 0;
while (list($tablename)=mysql_fetch_array($tables)) {
if($tablename == 'yourtable') {
$table_exist = 1;
}
}
if($table_exist == 0) {
//do something if it does not exist
} else {
//do something if it does exist
}

You can also access this info with an SQL query.
For example, MS SQL Server has the metatable sysobjects.

quick hint:
SELECT * FROM sysobjects WHERE name = 'TableName'