ADD a PRIVATE KEY and FOREIGN KEY to a TABLE

ADD a PRIVATE KEY and FOREIGN KEY to a TABLE

The best views to check CONSTRAINTS in a Database

ALL_CONSTRAINTS

all_cons_columns



PRIMARY KEY
************************************

Sample Script
************

ALTER TABLE table_name
ADD CONSTRAINT constraint_name
   PRIMARY KEY (column1, column2, ... column_n)
   REFERENCES parent_table (column1, column2, ... column_n);




ALTER TABLE QP_RTPN ADD CONSTRAINT PK_QP_RTPN_PARAM_ID PRIMARY KEY (ID)  REFERENCES QP_RTPN_PARAM (ID);



CREATE TABLE supplier
( supplier_id numeric(10) not null,
  supplier_name varchar2(50) not null,
  contact_name varchar2(50),
  CONSTRAINT supplier_pk PRIMARY KEY (supplier_id)

);

FOREIGN KEY

********************************

Sample script

************

ALTER TABLE table_name

ADD CONSTRAINT constraint_name

   FOREIGN KEY (column1, column2, ... column_n)

   REFERENCES parent_table (column1, column2, ... column_n);

ALTER TABLE QP_RTPN ADD CONSTRAINT FK_QP_RTPN_PARAM_ID FOREIGN KEY (ID)  REFERENCES QP_RTPN_PARAM (ID);

select * from all_cons_columns;

CREATE TABLE table_name

(

  column1 datatype null/not null,

  column2 datatype null/not null,

  CONSTRAINT fk_column

    FOREIGN KEY (column1, column2, ... column_n)

    REFERENCES parent_table (column1, column2, ... column_n)

);

ALTER TABLE employee ADD FOREIGN KEY (group_id) REFERENCES product_groups(ID);