Skip to end of metadata
Go to start of metadata

Overview

Creation of foreign key is available at the table level or column level in ALTIBASE HDB.

This is same with Oracle as well.

And Altibase's usage of foreign key has so much similarity to the Oracle's one.

But, Altibase HDB does not support exceptions Into clause.

EXAMPLE

ORACLE

ALTIBASE

ALTER TABLE dept_20
 ADD CONSTRAINT fk_empid_hiredate
 FOREIGN KEY (employee_id, hire_date)
 REFERENCES hr.job_history(employee_id, start_date)
 EXCEPTIONS INTO wrong_emp;

ALTER TABLE dept_20
ADD CONSTRAINT fk_empid_hiredate
FOREIGN KEY (employee_id, hire_date)
REFERENCES hr.job_history(employee_id, start_date);


Comparison of Functionality

ORACLE

ALTIBASE

Comments

[NOT] DEFERRABLE

 

 

INITIALLY (IMMEDIATE|DEFERRED)

 

 

ENABLE|DISABLE

ENABLE

Partially supported.

DISABLE NOVALIDATE|DISABLE VALIDATE
ENABLE NOVALIDATE|ENABLE VALIDATE

ENABLE (VALIDATE|NOVALIDATE)

Partially supported.

RELY|NORELY

 

 

ON DELETE (CASCADE|SET NULL)

ON DELETE(CASCADE|NO ACTION)

Set null functionality will be included in ALTIBASE HDB V7.

  • No labels