Table doesn't exist

schema:gisq

ORA-00942: table or view does not exist.

ORA-00942: table or view does not exist.

Error 1146 Table 'gisq.Bbc' doesn't exist

ORA-00942: table or view does not exist

ERROR: Relation "nosuchtable" does not exist

SQL0204N "GISQ.NOSUCHTABLE" is an undefined name

Msg 208 Invalid object name 'noSuchTable'

ORA-00942: table or view does not exist.

ORA-00942: table or view does not exist.

ORA-00942: table or view does not exist.

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.

SELECT * FROM Bbc

SELECT * FROM noSuchTable

In MySQL on LINUX the table names are case sensitive. This means that the table bbc exists but Bbc gives an error. This is a deviation from the SQL standard.

To get a list of all tables:

SELECT * FROM cat

ORDER BY TABLE_NAME

To get the names of all tables:

SELECT name FROM sysobjects
WHERE type='U'
ORDER BY name