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

0 vote156 views1 answer
Sql query for login with email or username
SQL
2 votes146 views3 answers
Row number mysql
SQL
2 votes151 views1 answer
Add new column not null sql server
SQL
0 vote160 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote129 views1 answer
Where case insensitive like mysql
SQL
1 vote170 views1 answer
Sql server read uncommitted
SQL
0 vote146 views1 answer
Consecutive numbers sql
SQL
3 votes153 views2 answers
Postgresql select all column names
SQL
2 votes138 views1 answer
How to find constraints on a table in oracle
SQL
3 votes170 views1 answer
RENAME table pl sql
SQL