how to alter table columns:

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 Received on Tue Aug 10 1999 - 12:18:15 CDT