How to Check if the table exists in SQL Server ?


This content was proof-read by Grammarly. You can Try Grammary for FREE

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.


Are you a .NET Developer planning to integrate GraphQL for .NET in your Application? Check out this book BUY & DOWNLOAD GRAPHQL.NET COOKBOOK
IF ( EXISTS (SELECT *
   FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_NAME = 'Employee'))
   BEGIN
     SELECT 'AC table found'
   END
%d bloggers like this: