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