How to Check if the table exists in SQL Server ?

Do you want to know if the table exists in a in SQL Server ? . Below is a sample query that lets you know if the table exists or not.

Assume that the table name is Employee , run the below query to know if the table exists in the SQL Server or not.

IF ( EXISTS (SELECT *
   FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_NAME = 'Employee'))
   BEGIN
     SELECT 'AC table found'
   END

SQL
​x
 
IF ( EXISTS (SELECT *
   FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_NAME = 'Employee'))
   BEGIN
     SELECT 'AC table found'
   END

Tags : Check, exists, How to, SQL Server, table

Abundant Code