SQL: how to find if a table exists?

I need to programmatically create a table if it does not already exists.

Is there an SQL statement that will allow me to query a DB to see if a
table exists?

Thanks,

Jc