All columns as primary key : Primary Key « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Primary Key
SQL>
SQL> create table keywords
  2  ( word  varchar2(50),
  3    position   int,
  4    doc_id int,
  5    primary key(word,position,doc_id)
  6  );

Table created.

SQL>
SQL> drop table keywords;

Table dropped.








6.15.Primary Key
6.15.1.Create a table with primary key, VARCHAR type column and date type column with default value
6.15.2.Alter table to insert primary key
6.15.3.Use combined column as the primary key
6.15.4.Try to add two primary keys to one table
6.15.5.All columns as primary key
6.15.6.One to many using a primary-key and foreign-key relationship
6.15.7.One-to-one using a primary-key and foreign-key relationship
6.15.8.Use three columns as primary key