Unknown object type ‘…’ used in a CREATE, DROP, or ALTER statement (Msg 343)

Alexandr Omelchenko Errors

Let’s consider the error “Unknown object type ‘…’ used in a CREATE, DROP, or ALTER statement” in the following example:

There is a need to add one more column “Column4” in the table “Table_1” which is located in the database “Adventureworks”. To execute this operation has been used the next syntax

ALTER Table_1 
ADD Column4 INT;

But the column was not added, and the SQL Server showed the following message:

Msg 343, Level 15, State 1, Line 3
Unknown object type 'Table_1' used in a CREATE, DROP, or ALTER statement.

This error occurs because SQL Server does not understand what to ALTER. In this case, it is necessary just to add TABLE after ALTER

ALTER TABLE Table_1 
ADD Column4 INT;