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

2 votes191 views2 answers
Storing timezones in postgres
SQL
1 vote181 views1 answer
PL SQL MODIFY COLUMN NME
SQL
4 votes197 views1 answer
Sql delete multiple conditions
SQL
1 vote172 views1 answer
Mysql how to reset primary key
SQL
1 vote192 views1 answer
Hangfire clear all jobs
SQL
0 vote159 views1 answer
Sql remove last x char
SQL
3 votes163 views1 answer
Sql server version query
SQL
7 votes182 views1 answer
Oracle reset sequence
SQL
0 vote192 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote192 views1 answer
Local pg_sql to heroku pg_sql
SQL