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

25 votes179 views6 answers
How to change column name in mysql
SQL
11 votes185 views1 answer
Sql insert multiple rows from select
SQL
13 votes177 views1 answer
Views in sql
SQL
0 vote181 views1 answer
Sql ignore
SQL
1 vote163 views1 answer
Set statiscis on in sql server
SQL
0 vote165 views3 answers
Create and attach user to a postgresql database
SQL
0 vote212 views3 answers
How to find all role in mysql
SQL
0 vote163 views1 answer
Nth max in my sql
SQL
0 vote153 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote162 views3 answers
Drop multiple columns in sql
SQL