check if some tables exist or not in SQL Server database What is the best way to check if more than one table exist in a database using SQL Server, I tried with this:

IF NOT EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'Providers') OR NOT EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'Customers') 


but is there a better way to do it  ?
Well if you turn on certain options in SSMS like "Check for object existence" you will get a script that looks like this when dropping and re-creating an object (e.g. table):

IF NOT EXISTS 
    (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[&lt;schema&gt;].[&lt;object_name&gt;]') 
        AND type in (N'U')
    )


Is it better? Uncertain.
Is it different? Yes.
Is it what Microsoft would do? Yes.