Difference between revisions of "Table doesn't exist"
From SQLZOO
(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...") |
|||
| (3 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
<div class='err'> | <div class='err'> | ||
<div class=params>schema:gisq</div> | <div class=params>schema:gisq</div> | ||
| − | <div class = "link e-oracle>ORA-00942: table or view does not exist.</div> | + | <div class = "link e-oracle">ORA-00942: table or view does not exist.</div> |
| − | <div class = "link e-access>ORA-00942: table or view does not exist.</div> | + | <div class = "link e-access">ORA-00942: table or view does not exist.</div> |
| − | <div class = "link e-mysql>Error 1146 Table 'gisq.Bbc' doesn't exist</div> | + | <div class = "link e-mysql">Error 1146 Table 'gisq.Bbc' doesn't exist</div> |
| − | <div class = "link e-sqlite>ORA-00942: table or view does not exist</div> | + | <div class = "link e-sqlite">ORA-00942: table or view does not exist</div> |
| − | <div class = "link e-postgres>ERROR: Relation "nosuchtable" does not exist</div> | + | <div class = "link e-postgres">ERROR: Relation "nosuchtable" does not exist</div> |
| − | <div class = "link e-db2>SQL0204N "GISQ.NOSUCHTABLE" is an undefined name</div> | + | <div class = "link e-db2">SQL0204N "GISQ.NOSUCHTABLE" is an undefined name</div> |
| − | <div class = "link e-sqlserver>Msg 208 Invalid object name 'noSuchTable'</div> | + | <div class = "link e-sqlserver">Msg 208 Invalid object name 'noSuchTable'</div> |
| − | <div class = "link e-ingres>ORA-00942: table or view does not exist.</div> | + | <div class = "link e-ingres">ORA-00942: table or view does not exist.</div> |
| − | <div class = "link e-mimer>ORA-00942: table or view does not exist.</div> | + | <div class = "link e-mimer">ORA-00942: table or view does not exist.</div> |
| − | <div class = "link e-sybase>ORA-00942: table or view does not exist.</div> | + | <div class = "link e-sybase">ORA-00942: table or view does not exist.</div> |
<div> | <div> | ||
<h2>Problem</h2> | <h2>Problem</h2> | ||
| Line 41: | Line 41: | ||
</div> | </div> | ||
</div> | </div> | ||
| + | [[Category:Error]] | ||
Latest revision as of 13:20, 9 August 2012
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
