Add column in a PK

[lobo]

Hello Friends of Oracle

I would like to know how to add a column in a PK.
If someone can help me thank you.

ATT,

Dan

[gilbertoca]

If you have created your table without restriction, that is, without the primary key, do the following:

Select all

 
CREATE TABLE CHAVE( 
  CHAVE_PRIMARIA NUMBER NOT NULL, 
  DESCRICAO VARCHAR2(60) 
); 
 
ALTER TABLE CHAVE ADD CONSTRAINT CHAVE_PK PRIMARY KEY (CHAVE_PRIMARIA); 

or if the table already has the primary key but you want to add a column in the primary key, You need to delete the restriction first and then rebuild it:

Select all

 
CREATE TABLE CHAVE( 
  CHAVE_PRIMARIA NUMBER NOT NULL, 
  CHAVE_SECUNDARIA VARCHAR2(5) NOT NULL, 
  DESCRICAO VARCHAR2(60), 
  CONSTRAINT CHAVE_PK PRIMARY KEY (CHAVE_PRIMARIA ) )   
); 
 
ALTER TABLE CHAVE DROP CONSTRAINT CHAVE_PK; 
ALTER TABLE CHAVE ADD CONSTRAINT CHAVE_PK PRIMARY KEY (CHAVE_PRIMARIA, CHAVE_SECUNDARIA); 

CAUTION! I did not run this script! You better test the syntax first.
until
Gilberto