Table doesn't exist
Revision as of 11:30, 19 July 2012 by Connor (Created page with "<div class='err'> <div class=params>schema:gisq</div> <div class = "link e-oracle>ORA-00942: table or view does not exist.</div> <div class = "link e-access>ORA-00942: table o...")
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.
- 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 catORDER BY TABLE_NAME
To get the names of all tables:
SELECT name FROM sysobjects WHERE type='U' ORDER BY name