Tuesday, March 24, 2009

Creating Inter Schema Foreign Key

1: Needs REFERENCE grant on Particular Tables
GRANT REFERENCES (employee_id),UPDATE (employee_id, salary, commission_pct)ON hr.employeesTO JAGAT;

2: Create table with foreign key
CREATE TABLE dependent(dependno NUMBER,dependname VARCHAR2(10),employee NUMBERCONSTRAINT in_emp REFERENCES SCOTT.employees(employee_id) );

No comments:

Post a Comment