How to check if table exists in SQL?

Question

Can anyone tell me how to check if the table exists in SQL?

Answer 1

Here is the SQL query to check if the Employee table exists in SQL server:

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'Employee')

BEGIN

    PRINT 'Table Exists'

END

In MySQL, there is a simple query to check if the Employee table exists:

SHOW TABLES LIKE '%Employee%';

If you want to learn SQL from Industry experts then check out this SQL course by Intellipaat that provides Instructor-led training, hands-on experience, and certification.