How can I check to see if SQL tables exist in a specified database and simply return a 'no' if they dont exist and a 'yes' if they do exist?
---------Thanks---------
Different DBMS's have different functions for this, but I guess the best generic way would be:
SELECT COUNT(*) AS NUMRECS FROM whateverTable
If you get a result, the table exists. If you don't get a result, the table does not exist.
