T-SQL Tutorial

Msg 208 Level 16 - Invalid object name


On Transact SQL language the Msg 200 Level 16 - Invalid object name means that we have in our statement the table name misspelled or table does not exist.

Msg 208 Level 16 Example:

We have the table test_table.

IdName
1Object 1
2Object 2

Invalid object name:

USE model;
GO
SELECT * FROM test_table3411;
GO

Message
Msg 208, Level 16, State 1, Line 1
Invalid object name 'test_table3411'.




Correct object name:

USE model;
GO
SELECT * FROM test_table;
GO

IdName
1Object 1
2Object 2

Other error messages: