Re: Portable way to DROP a COLUMN?..

> It is (or ought to be "trivial") from the SQL syntax perspective.

There are multiple levels to the ANSI SQL standard. In order for a RDBMS vendor to put the "ANSI SQL compliant" tag on their product, they only need to comply with the entry level of the ANSI SQL standard. DDL operations are not in the entry level, as such, the same operation's syntax can vary from one RDBMS vendor to another.

What should happen, and what does happen are two different things here.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown