Alter table to insert primary key : Primary Key « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Primary Key
SQL> CREATE TABLE department (
  2  dept_id           INTEGER,
  3  dept_name     VARCHAR2(32));


SQL>
SQL> ALTER TABLE department
  2  ADD CONSTRAINT pk_dept PRIMARY KEY (dept_id);

Table altered.


SQL>
SQL> drop table department;

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