Difference between revisions of "Table doesn't exist"

From SQLZOO
Jump to: navigation, search
(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...")
 
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>

Revision as of 12:32, 19 July 2012

schema:gisq

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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense