Re: ALTER TABLE DROP COLUMN ?
Date: 1996/02/02
Message-ID: <4esb86$pqq_at_news2.ios.com>#1/1
In article <4emckd$2i9_at_news.icubed.com>,
jbgreene_at_infobahn.icubed.com (Joe Greene) wrote:
>In article <4ei2pf$76j_at_maya.dei.unipd.it>, qwerty_at_chiara.dei.unipd.it (Luigi
>Scappin 264462/IL) wrote:
>> Hi.
>> I'm loking for an Oracle SQL statement to DROP a COLUMN in a database
table.
>> I think it's a stupid question... but I don't know how... :-)
>>
>You can alter it and make it null, but I do not believe that you can drop a
column.
Just rewrite table to temp_table and create table AS table new without don't_want_it_column
Dave
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2
mQBtAzDy7iQAAAEDANFqUWj3YO9PZLkyZxI8yVviE7oB3X3pu4G7XFMsFzrro6Dk
FZUQ3kZZkS+oVZXr/TZkdAMzhKVy/w5PTGzkW1Aqa/95tKcfel6UWOu6AqWs4Kpf
hihofIw5z+PCbSmWlQAFEbQkRGF2aWQgQi4gUGFpcyA8ZGF2aWRwM0Bzb2hvLmlv
cy5jb20+
=Z74b
-----END PGP PUBLIC KEY BLOCK-----
Received on Fri Feb 02 1996 - 00:00:00 CET