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

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.

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

Replies are listed 'Best First'.
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]