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.
| Id | Name |
|---|---|
| 1 | Object 1 |
| 2 | Object 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
| Id | Name |
|---|---|
| 1 | Object 1 |
| 2 | Object 2 |
Other error messages:
- There are more columns in the INSERT statement than values specified in the VALUES clause
- Must declare the scalar variable
- Is not a recognized datepart option
- The definition for column must include a data type
- Is not a recognized built-in function name
- Invalid column name
- Operand type clash: int is incompatible with date
