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 a Reply

Your email address will not be published. Required fields are marked *

Liked this content?. Please spread the word :)

  • RSS
  • Twitter
    Visit Us
    Follow Me