Foreign Keys Questions and Answers

Recent IT Questions

1 - 3 of 3
<<PREVIOUS 1 NEXT>>

Composite foreign Key in SQL Server

I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel,...

asked by GabyCostilla

  5 pts.

ORA-01031 Insufficient privileges

I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

View Answer   |  Jun 16 2009  6:51 AM GMT
ORA-01031, Foreign keys, Primary keys
asked by SRDBA

  5 pts.

Oracle Application Express Item

I have two tables with parent-child relationship. Is there a way to automatically populate the foreign key field of the child table with the exact data from the primary key of the parent table?

View Answer   |  Apr 8 2008  1:04 PM GMT
Oracle, Database, Primary keys
asked by Rwy

  15 pts.

1 - 3 of 3
<<PREVIOUS 1 NEXT>>