How to determine whether a table exists in SQL Server

Objects such as tables in the SQL Server database are stored in the sysobjects data table, and temporary tables are saved in the tempdb database.

1. Determine whether a common table exists. You can use the object_id function to return the Object ID based on the object name.

 
If(Select Object_id('Tablename'))Is Not NullSelect 'True'ElseSelect 'False'
 

Or

 If  Exists ( Select   [  ID  ]   From   [  Sysobjects  ]   Where   [  Name  ]  =  '  Tablename  '  ) Select   '  True  '  Else      Select   '  False  ' 

2. Determine whether a temporary table exists
(1) common temporary tables

If(Select Object_id('Tempdb .. # temptablename'))Is Not NullSelect 'True'ElseSelect 'False'
 

(2) Global temporary table

  If  ( select   object_id  ( '  tempdb .. # temptablename   ')  is   not   null   select   '  true   '  else   select   '  Fals