Sql server check table exists

T-sql test if table exists

IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'TheSchema' 
                 AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

Source: stackoverflow.com

Sql server check table exists

IF EXISTS 
  (SELECT object_id FROM sys.tables
  WHERE name = 'Artists'
  AND SCHEMA_NAME(schema_id) = 'dbo')
  PRINT 'The table exists'
ELSE 
  PRINT 'The table does not exist';

Source: database.guide

Similar codes

14 votes227 views4 answers
Remove record from table sql
SQL
14 votes220 views3 answers
Sql trim from string
SQL
19 votes213 views6 answers
What is mySQL
SQL
0 vote225 views1 answer
How to get table current identity value in sql server
SQL
0 vote211 views1 answer
Add column not null with default value postgres
SQL
0 vote208 views1 answer
Double in sql server example
SQL
2 votes234 views3 answers
Sql interview query questions
SQL
6 votes254 views2 answers
Install psql mac
SQL
3 votes240 views1 answer
Sql add two values together
SQL
0 vote208 views1 answer
Create function syntax sql server
SQL