Re: Can we remove a column from a table??
From: ??? <ywkang_at_itnc.co.kr>
Date: Wed, 02 Feb 2000 01:49:14 GMT
Message-ID: <u2Ml4.8$255.546_at_news2.bora.net>
Date: Wed, 02 Feb 2000 01:49:14 GMT
Message-ID: <u2Ml4.8$255.546_at_news2.bora.net>
You can remove column by
'alter table XXX(table name) drop column YYY(column name);'
but this statement is available only in Oracle8i 8.1.5 version.
I think the removable column has no data.
"peter" <misybh_at_hmc.com.tw> wrote in message
news:38952DF3.9B9654EC_at_hmc.com.tw...
> hi..
> I have a table named 'test' which has 3 columns..
> Can I remove one column????
>
> we all know that we can use SQL command to alter a table
> but it seems that we only add or modify a column ..
> How can we remove a column from a table???
>
>
Received on Wed Feb 02 2000 - 02:49:14 CET