Sql foreign key constraint. a foreign key is a key used to link two tables together. a foreign key is a field (or collection of fields) in one table that refers to the primary key in another table. the table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.. Just create foreign keys as initially deferred, this not require any special workarounds: connected to: oracle database 10g express edition release 10.2.0.1.0 - production sql> create table p ( 2 code number primary key, 3 name varchar2(100) 4 ); table created.. In ms sql server it is possible to create a foreign key with on update cascade option, so whenever you update one of the columns in the primary key, the foreign keys in other tables will also be update by the dbms..
More discussions in sql & pl/sql. foreign keys. 507350 jul 31, 2007 1:19 pm is there any option in oracle to automatically update the foreign key column values, whenever the primary key column is getting updated ? thanks andr
