One-to-one using a primary-key and foreign-key relationship : Create Primary Key « Constraints « Oracle PL / SQL






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

One-to-one using a primary-key and foreign-key relationship

   
SQL>
SQL>
SQL> CREATE TABLE Office
  2     (office_id        VARCHAR2(10) NOT NULL,
  3      building_name    VARCHAR2(20),
  4      PRIMARY KEY (office_id));

Table created.

SQL>
SQL> CREATE TABLE Programmer
  2     (lect_id    VARCHAR2(10) NOT NULL,
  3      lect_name  VARCHAR2(20),
  4      office_id  VARCHAR2(10),
  5      PRIMARY KEY (lect_id),
  6      FOREIGN KEY (office_id) REFERENCES Office (office_id)
  7      ON DELETE CASCADE);

Table created.

SQL>
SQL> drop table Office cascade constraints;

Table dropped.

SQL> drop table Programmer cascade constraints;

Table dropped.








Related examples in the same category

1.Using a CREATE TABLE statement: create a table with primary key
2.Create a foreign key "set null on delete" with more than one field, and use desc to check
3.Violate the primary key and foreign key relation
4.ORA-12991: column is referenced in a multi-column constraint
5.Use three columns as primary key
6.Set primary key when declaring a column