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 vote264 views1 answer
Interview experience as a call?
SQL
1 vote319 views1 answer
Drop colum oracle 18c
SQL
-1 vote259 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote215 views1 answer
Check if due date is less than todays date sql
SQL
0 vote267 views1 answer
Odd record sql query
SQL
0 vote256 views3 answers
Get free card roblox
SQL
14 votes276 views3 answers
Delete all records from table except sql
SQL
0 vote276 views1 answer
Oracle running queries
SQL
0 vote294 views1 answer
Min:sec datediff mssql
SQL
0 vote260 views1 answer
Sql select by content lenght
SQL