Invalid object name (Msg 208)

The “Invalid object name…” error appears when the name of the selected object is incorrect. For example, there is a need to selected “Column1” from the “Table_2” from the database “Adventureworks”, the following syntax was used:

SELECT Column1
FROM Tabl_2

In this case, SQL Server will send the next error:

Msg 208, Level 16, State 1, Line 4
Invalid object name 'Tabl_2'.

Let’s check the names of all tables in the database. It was found that there was a mistake, instead “Table_2” was “Tabl_2”. The following syntax should be applied to select “Column1” from “Table_2”:

SELECT Column1
FROM Table_2