Re: how to alter table columns:

Unless you are using 8i, you cannot....

The way I would handle it is to create a new table with the column names you want, and populate it with a select * from cmpd...[ if the same # of columns ] you can then drop cmpd and rename your new table to cmpd...

Hope it helps,

Zahid Khan <zahid_at_cc.gatech.edu> wrote:

>1.] I have a table declared as :
>
>create table cmpd (
>cmpd_formula varchar2(20),
>ca_number varchar2(10));
>
>But now I want to change the name of the field ca_number to ca_no How do
>I do this?
>
>2.] I have the cmpd_formula field declared as a primary key. But now
>I've decided that I don't want it to be the primary key. How do I make
>this change?
>
>TIA
>--zahid

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Aug 10 1999 - 15:01:42 CDT