Re^3: DBI: checking if a table exists in a cross-DB manner?

You're absolutely correct. But AFAIK, all of the big names support it. I've yet to use a database that didn't have it.

thor

Feel the white light, the light within Be your own disciple, fan the sparks of will For all of us waiting, your kingdom will come

Comment on Re^3: DBI: checking if a table exists in a cross-DB manner?

Replies are listed 'Best First'.
Re^4: DBI: checking if a table exists in a cross-DB manner? by htoug (Deacon) on Dec 03, 2004 at 14:02 UTC
Depends on what you call 'the big names'. FWIW Ingres doesn't support it - to name a rather 'big' open-source RDBMS. Instead you have `MODIFY table TO TRUNCATE`. But that's not SQL-9X either.	[reply]
Re^5: DBI: checking if a table exists in a cross-DB manner? by thor (Priest) on Dec 03, 2004 at 21:13 UTC
As an aside, I wonder if there's a forthcoming SQL standard that specifies a common syntax for this. It seems like a useful thing to do...even if the backend translates it to "DELETE FROM table". thor `Feel the white light, the light within Be your own disciple, fan the sparks of will For all of us waiting, your kingdom will come`	[reply]
Re^4: DBI: checking if a table exists in a cross-DB manner? by herveus (Prior) on Dec 03, 2004 at 13:19 UTC
Howdy! OK. But SQLite does not appear to support it, to name one very useful non-big name. yours, Michael	[reply]
Re^5: DBI: checking if a table exists in a cross-DB manner? by thor (Priest) on Dec 03, 2004 at 13:44 UTC
Getting around to learning that has been on my "to-do" list for a while, so I guess it's no surprise that I didn't know that. I stand corrected. :) thor `Feel the white light, the light within Be your own disciple, fan the sparks of will For all of us waiting, your kingdom will come`	[reply]