How to check table exists in SQL Server?

Question

Aryan Kumar · Answer

Sure, I can help you with that. Here are two ways to check if a table exists in SQL Server:

The IF EXISTS clause is a conditional statement that can be used to check if a table exists. The syntax for the IF EXISTS clause is as follows:

SQL

IF EXISTS (
    SELECT *
    FROM sys.tables
    WHERE name = 'table_name'
)
BEGIN
    -- Code to execute if the table exists
END;

The table_name is the name of the table that you want to check if it exists.

For example, the following code will check if the Customers table exists:

SQL

IF EXISTS (
    SELECT *
    FROM sys.tables
    WHERE name = 'Customers'
)
BEGIN
    PRINT 'The Customers table exists.';
END;

The OBJECT_ID() function can be used to get the object ID of a table. If the table does not exist, the OBJECT_ID() function will return NULL.

The syntax for the OBJECT_ID() function is as follows:

SQL

SELECT OBJECT_ID('table_name');

The table_name is the name of the table that you want to get the object ID for.

For example, the following code will check if the Customers table exists:

SQL

DECLARE @table_id INT;

SET @table_id = OBJECT_ID('Customers');

IF @table_id IS NOT NULL
BEGIN
    PRINT 'The Customers table exists.';
END;

forum