Create a primary key with more than one field : Primary Key « Constraints « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Constraints
  3. Primary Key

Create a primary key with more than one field


SQL> -- Create a primary key with more than one field:
SQL>
SQL>
SQL> CREATE TABLE supplier
  2  (  supplier_id     numeric(10)     not null,
  3     supplier_name   varchar2(50)    not null,
  4     contact_name    varchar2(50),
  5     CONSTRAINT supplier_pk PRIMARY KEY (supplier_id, supplier_name)
  6  );

Table created.

SQL>
SQL> desc supplier;
 Name                                                                                                  Null?    Type
 ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------

 SUPPLIER_ID                                                                                           NOT NULL NUMBER(10)
 SUPPLIER_NAME                                                                                         NOT NULL VARCHAR2(50)
 CONTACT_NAME                                                                                           VARCHAR2(50)

SQL>
SQL> drop table supplier;

Table dropped.

SQL>
SQL>








Related examples in the same category

1.Primary Key: A primary key combines a unique and a not null constraint
2.Alter to add primary key
3.DISTINCT keyword with primary key in select clause