Re: sqlplus alter question

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 11 Apr 1998 01:46:21 GMT
Message-ID: <6gmi27$9kk@bgtnsc03.worldnet.att.net>

On Thu, 09 Apr 1998 17:46:34 -0500, Martin Meadows <mmeadows_at_indy.net> wrote:

>Yesterday I added a column to a table & immediately realized that I
>should have called it something other than what I called it. I then
>wanted to rename it but couldn't figure out how. As an alternative I
>tried to "drop" it but couldn't get that to work either. What's the
>trick?

No trick. You have to drop the entire table and recreate it--really.

Jonathan Received on Fri Apr 10 1998 - 20:46:21 CDT