Question

How to find which tables are present in a database of sql server?

Answer 1

You can use this to check if a table exists;

IF (EXISTS (SELECT *  

                FROM INFORMATION_SCHEMA.TABLES  

                WHERE TABLE_SCHEMA = 'TheSchema'  

                AND  TABLE_NAME = 'TheTable'))

BEGIN

   --Do Stuff

END