in reply to How to create tables with DBI?

What you're asking for is nearly impossible to provide. Portability is the biggest--of several--problems with SQL.

There is an ANSI standard for SQL that all SQLDBs must comply with to to earn the name, but this standard is so lowest-common-denominator, that sticking to it makes your application very hard, very inefficient, or both. Or even impossible within the constraints of practicality.

And even if you stick rigidly to the ANSI standard, the exact same syntax can produce wildly differing results on different complient platforms. Eg. Think ANSI Standard SQL Is Fully Portable Between Databases? Think Again..


Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
"I'd rather go naked than blow up my ass"