207: Invalid column name
SQL ServerWhat does it mean?
The column name referenced in the query was not found in the table/view. No column exists with that name, or it is out of scope.
Why does it happen?
A spelling/case error, the wrong table alias, a column not yet added or renamed, the wrong schema/table context, or omitting square brackets instead of quotes.
How to fix it
Verify the column name and table (check sys.columns or Object Explorer). Use the correct alias and schema. For newly added columns, make sure the object is up to date; recompile the stored procedure if needed. Use square brackets for names containing spaces/special characters.
More from this engine
- 515Cannot insert the value NULL into column
- 8115Arithmetic overflow error converting expression to data type
- 512Subquery returned more than 1 value
- 156Incorrect syntax near the keyword
- 2812Could not find stored procedure
- 8623The query processor ran out of internal resources and could not produce a query plan
- 4104The multi-part identifier could not be bound