Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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

by htoug (Deacon)
on Dec 03, 2004 at 14:02 UTC ( #412124=note: print w/ replies, xml ) Need Help??


in reply to Re^3: DBI: checking if a table exists in a cross-DB manner?
in thread 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?
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://412124]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2014-07-29 22:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (229 votes), past polls