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

Howdy!

'TRUNCATE TABLE' is not, so far as I can tell, standard SQL, and isn't necessarily going to be available. The index to the SQL-92 standard has no entry for 'truncate'. I don't know about newer SQL standards, but SQL-92 seems to be still widely used as a basis.

yours,
Michael

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

Replies are listed 'Best First'.
Re^3: DBI: checking if a table exists in a cross-DB manner? by thor (Priest) on Dec 03, 2004 at 13:15 UTC
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`	[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]
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]