Re: How to delete a column from a table?

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 1997/03/11
Message-ID: <ObmHCIAfSbJzEwNS@ahardy.demon.co.uk>#1/1

In article <33252A4F.3700_at_pmcgettigan.demon.co.uk>, Steve Phelan <stevep_at_pmcgettigan.demon.co.uk> writes
>Andy Hardy wrote:
>>
>>

 [snip]
>>
>> By creating a view he saves having to recreate the indexes, constraints,
>> etc.
>>
>> Andy Hardy. PGP key available on request
>> ===============================================================
>> Grosch's Law
>> Computing power increases as the square of the cost.
>
>True, but would you want a view hanging around your database to make a
>table look different when what you really wanted to do was get rid of a
>column in the table in the first place? (And Inserts would always have
>to refer to the column if it was declared as NOT NULL when the table was
>created). The view just seemed to be a very messy way of not reaching
>the desired goal, IMHO.
>
>Steve Phelan.

Very messy, true. However, it can be useful during development - having created and populated a table which is no longer of the shape required.

Andy Hardy. PGP key available on request

---

Anyone who is capable of getting themselves made President should on no account be allowed to do the job.

• Douglas Adams, "The Hitchhiker's Guide to the Galaxy"

Received on Tue Mar 11 1997 - 00:00:00 CST