oracle外鍵約束子表、父表

字號:


    create table employees(
    employee_id number(6),
    last_name varchar2(25) not null,
    email varchar2(25),
    salary number(8,2),
    commission_pct number(2,2),
    hire_date date not null,
    ...
    department_id number(4),
    constraint emp_dept_fk foreign key (department_id)
    references departments(department_id),
    constraint emp_email_uk unique(email));
    foreign key:在表級指定子表中的列
    references:標(biāo)識在父表中的列
    on delete cascade:當(dāng)父表中的列被刪除時,子表中相對應(yīng)的列也被刪除
    on delete set null:子表中相應(yīng)的列置空