Error 207

Severity Level 16
Message Text

Invalid column name '%.*ls'.

Explanation

This error occurs when a column referenced in a Transact-SQL statement was not found in any table specified in the FROM clause of the query.

Action

Change the column name to a column name present in one of the tables referenced in the query.

This example returns error 207:

USE Northwind

GO

SELECT CategoryName1

FROM Categories

GO

  

Evaluate the problem by looking at the full command. For the above example, ensure that the SELECT statement contains the name of a valid column name (CategoryName rather than CategoryName1 as specified above) for the specified table.

USE Northwind

GO

SELECT CategoryName

FROM Categories

GO

  

See Also
Errors 1 - 999 SELECT

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.