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:
Using the IF EXISTS clause
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;
Using the OBJECT_ID() function
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

How to check table exists in SQL Server?

Revati S Misra

Can you answer this question?

1 Answers

Liked By