Check if a table exist in where

Question

This query generates an error because table2 doesn't exist:

Select * FROM table WHERE table2.id IS NOT NULL

Is there anything like this for check the table2 before apply the check on the id?

Select * FROM table WHERE (EXIST(table2) AND table2.id IS NOT NULL) or not EXIST(table2)

My SQL may be rusty but how do you reference "table2" when you did not include it in the FROM portion of the query? — The Real Diel
– The Real Diel, Commented Jun 2, 2010 at 14:28

LesterDove · Accepted Answer · 2010-06-02 14:20:28Z

You need to query this system table:

SELECT table_name FROM information_schema.tables WHERE table_schema = 'yourdatabasename' AND table_name = 'table2';

If a row is returned, then your table exists.

Chris · Accepted Answer · 2010-06-02 14:24:53Z

I do not believe there is any command or function in standard SQL to do this. You could query the data dictionary to check if the table exists before issuing your SQL query as follows:

SELECT table_name FROM INFORMATION_SCHEMA.tables WHERE table_name = 'xxx';

I do not think it could be done in a single SQL statement though.

Collectives™ on Stack Overflow

Check if a table exist in where

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related