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.

How to Check if the table exists in SQL Server ?

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

Leave Your Comment

Liked this content?. Please spread the word :)