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

31 votes332 views2 answers
Grant all priviledges to mysql user
SQL
23 votes312 views4 answers
How to uninstall postgresql in ubuntu
SQL
1 vote339 views3 answers
Sql union
SQL
0 vote352 views1 answer
How to fetch data from database in sql
SQL
0 vote325 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote335 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
2 votes309 views3 answers
How to get second highest salary in each department in sql
SQL
2 votes340 views6 answers
Mysql change timezone
SQL
0 vote297 views1 answer
Sql view index
SQL
1 vote301 views1 answer
Set statiscis on in sql server
SQL