Re: Portable way to DROP a COLUMN?..

From: Mikhail Teterin <usenet+meow_at_aldan.algebra.com>
Date: Thu, 21 Sep 2006 23:18:35 -0400
Message-Id: <1355337.BoFOOu9uLf@aldan.algebra.com>

gazzag wrote:

> It must be a very strange/loose data model that considers dropping a
> column "trivial". Generally speaking, DDL should not be performed by
> any application.

It is (or ought to be "trivial") from the SQL syntax perspective. Table alterations are among the most obvious operations and should've been in the SQL syntax since very beginning -- unlike with the later-added extensions (such as Oracle's "LIKE_REGEX"), I see no excuse for the vendors on this one.

Why our application chooses to do it is outside of the scope of my question.

-mi Received on Thu Sep 21 2006 - 22:18:35 CDT