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.
IF ( EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Employee')) BEGIN SELECT 'AC table found' END