Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
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 ( [id://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.

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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-03-29 11:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found