Eine Einführung in

SQL

Msg 208 Invalid object name 'noSuchTable'

MS SQL Server

Problem

An attempt was made to read from a table that does not exist.

Most likely the table name has been spelt incorrectly.

Possibly the table is not in the current schema or database.

Solutions

  • Correct the spelling of the table name.


Specific to MS SQL Server
To get the names of all tables:
SELECT name FROM sysobjects
WHERE type='U'
ORDER BY name